Thread: [Rainbowportal-devel] cpu times used on startup?
Brought to you by:
danijel_kecman,
manudea
From: Chris F. <ch...@cf...> - 2004-02-17 05:02:24
|
Gang I was trying to be helpful in the forums but really this is a topic I'm not that involved in. I do see this comment often and in some recent testing I am a bit curious as well. forums post http://www.rainbowportal.net/AspNetForums/ShowPost.aspx?PostID=6244 A very common and valid question. Why the first page takes so long to load. Why isn't webcompile keeping it alive? 2: Just testing on my system, a 1.2ghz AMD running Windows XP and an evaluation version of SQL Server 2000. aspnet_wp.exe 13 seconds cpu time. sqlserver.exe 11 seconds cpu time. Why on earth would sql server need 11 seconds cpu time? Can there really be that many queries in startup to justify 11 seconds cpu time? I have done some database projects that involved far more data, horribly complex many table joins, etc on access 2k and it didn't use 3 seconds of cpu time. Using issreset.exe I purged the aspnet_wp.exe process and any cache. Reloaded the Rainbow portal and also the IBuySpy portal. Consistently rainbow took 9-11 seconds cpu time in sql server, IBuySpy portal used less than a second in the sqlserver.exe process. Is something wrong here? Chris Farrell ch...@cf... http://www.cftechconsulting.com |
From: William F. <bi...@im...> - 2004-02-17 15:27:03
|
I was looking around and saw this in a recent codeproject mailing... It = uses class/property attributes to generate SQL tables & column = structure. It is pretty primitive, but with a little work it might be = modified to alter existing tables, generate new database elements or = whatever based just on those class attributes. Thought it might be = handy... http://www.codeproject.com/useritems/Schema.asp<http://www.codeproject.co= m/useritems/Schema.asp> ----- Original Message -----=20 From: Chris Farrell<mailto:ch...@cf...>=20 To: = rai...@li...<mailto:rainbowportal-devel@list= s.sourceforge.net>=20 Sent: Monday, February 16, 2004 8:55 PM Subject: [Rainbowportal-devel] cpu times used on startup? Gang I was trying to be helpful in the forums but really this is a topic = I'm=20 not that involved in. I do see this comment often and in some recent testing I am a bit = curious=20 as well. forums post = http://www.rainbowportal.net/AspNetForums/ShowPost.aspx?PostID=3D6244<htt= p://www.rainbowportal.net/AspNetForums/ShowPost.aspx?PostID=3D6244> A very common and valid question. Why the first page takes so long to = load. Why isn't webcompile keeping it alive? 2: Just testing on my system, a 1.2ghz AMD running Windows XP and an=20 evaluation version of SQL Server 2000. aspnet_wp.exe 13 seconds cpu time. sqlserver.exe 11 seconds cpu time. Why on earth would sql server need 11 seconds cpu time? Can there = really=20 be that many queries in startup to justify 11 seconds cpu time? I have done some=20 database projects that involved far more data, horribly complex many table joins, etc on = access 2k=20 and it didn't use 3 seconds of cpu time. Using issreset.exe I purged the aspnet_wp.exe process and any=20 cache. Reloaded the Rainbow portal and also the IBuySpy portal. Consistently rainbow took = 9-11=20 seconds cpu time in sql server, IBuySpy portal used less than a second in the=20 sqlserver.exe process. Is something wrong here? Chris Farrell ch...@cf...<mailto:ch...@cf...> http://www.cftechconsulting.com<http://www.cftechconsulting.com/> ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! = http://ads.osdn.com/?ad_id=3D1356&alloc_id=3D3438&op=3Dclick<http://ads.o= sdn.com/?ad_id=3D1356&alloc_id=3D3438&op=3Dclick> _______________________________________________ Rainbowportal-devel mailing list = Rai...@li...<mailto:Rainbowportal-devel@list= s.sourceforge.net> = https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel<https://= lists.sourceforge.net/lists/listinfo/rainbowportal-devel> |
From: Cory I. <cis...@ya...> - 2004-02-19 03:20:15
|
Chris, The Webcompile only runs on first hit, but it runs in a separate thread. The application is not JIT compiled in any way until it is executed once. IBUYSPY is much smaller than Rainbow so it makes sense that it compiles faster. There may be additional things going on as well. I will make a note to work on improving that in the next version. Cory Isakson http://blog.coryisakson.com/ ----- Original Message ----- From: "Chris Farrell" <ch...@cf...> To: <rai...@li...> Sent: Monday, February 16, 2004 9:55 PM Subject: [Rainbowportal-devel] cpu times used on startup? > Gang > I was trying to be helpful in the forums but really this is a topic > I'm > not that involved in. > I do see this comment often and in some recent testing I am a bit > curious > as well. > > forums post > http://www.rainbowportal.net/AspNetForums/ShowPost.aspx?PostID=6244 > A very common and valid question. Why the first page takes so long to > load. Why isn't > webcompile keeping it alive? > > 2: Just testing on my system, a 1.2ghz AMD running Windows XP and an > evaluation version > of SQL Server 2000. > > aspnet_wp.exe 13 seconds cpu time. > sqlserver.exe 11 seconds cpu time. > > Why on earth would sql server need 11 seconds cpu time? Can there > really > be that many > queries in startup to justify 11 seconds cpu time? I have done some > database projects that > involved far more data, horribly complex many table joins, etc on > access 2k > and it didn't > use 3 seconds of cpu time. > > Using issreset.exe I purged the aspnet_wp.exe process and any > cache. Reloaded the > Rainbow portal and also the IBuySpy portal. Consistently rainbow took > 9-11 > seconds cpu > time in sql server, IBuySpy portal used less than a second in the > sqlserver.exe process. > > Is something wrong here? > > Chris Farrell > ch...@cf... > http://www.cftechconsulting.com > > > > > ------------------------------------------------------- > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > Build and deploy apps & Web services for Linux with > a free DVD software kit from IBM. Click Now! > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > _______________________________________________ > Rainbowportal-devel mailing list > Rai...@li... > https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel |