I uploaded this to a hosting site. The DB is SQL 2000 and is shared. The performance is unbearable. The technical support says that the DB CPU goes up to 100% when page requests are being made. This is basically a fresh install of RC3 (Very little data). I
had to use a SQL DTS package to push the tables to the new DB. I did notice that the rainbow site is pretty slow itself Has anyone else experienced less then desirable performance?
Hi, The next release makes better use of caching to reduce the number of times it hits the database. This has improved performance quite a bit. A new release is due in the next two weeks. Regards, John
The database is, most likely, not the culprit of the CPU spike. Something to consider is the virus scanning software your host may be using. Until the release of McAfee 7.1, when I ran any .NET application with a db interdependency, response time was ridiculously
increased. More details about virus scanners and their effects on .NET applications can be found at the MSDN web site, particularly those referring to the virus scanners "flipping" the archive bit on the .NET application config files causing a looping of application
initialization. McAfee 8.0 on the other hand causes a whole new set of problems.
None
0 Points
1 Post
Database perfomance is VERY BAD. RC3
Jun 16, 2004 11:30 AM|DotNutter|LINK
None
0 Points
108 Posts
Re: Database perfomance is VERY BAD. RC3
Jun 28, 2004 02:20 AM|John_Mandia|LINK
http://weblogs.asp.net/jmandia
http://www.silverlightseo.net/
http://twitter.com/jmandia
None
0 Points
8 Posts
Re: Database perfomance is VERY BAD. RC3
Nov 22, 2004 01:47 PM|frankdotnet|LINK