Slooooooooooooooooooooooowwww!
-
First I have to say that I really LOVE this site, and the forums :-) I have a few questions I really would like you to answar; How many daily sessions are there on this site? How many pagehits? What database are you using? (SQL Server 7.0 I guess) I can see that you are using IIS 5.0... Are the webserver and database server on the same hardware-box? What kind of hardware runs the database server (processors, ram, disks, raid)? How big is the database-file? I mean, I have been working with databases for several years, and I have seen queries that took almost 30 seconds to execute, but when we optimized the SQL code, they executed in under 1 second... No offence, really, I have a great respect for you guys, it's just that I know my way around SQL Server, and don't see why it's so slow... Lately Chriss was talking about a Serverfarm, a database cluster and that kinda stuff, but I guess you haven't implemented it yet... - Anders
Hey Anders, The big problem is that we are connecting to the databases multiple times for a page, and executing multiple queries where only a single query is really needed. The site simply grew too big too fast (not that that's a bad thing!) and as is often the way, our 'proof of concept' site became our production site. Hence the work being done on rewriting from scratch to do away with all the kludges and do it 'right'. It's a juggling act between ensuring that articles get posted and updates made, and ensuring that we try and get the new site written ASAP. Uwe has been working on rewriting the forums to reduce the number of queries which should take a load off. Hardware is still coming, .NET is still coming - all sorts of things are still coming :) cheers, Chris Maunder
-
First I have to say that I really LOVE this site, and the forums :-) I have a few questions I really would like you to answar; How many daily sessions are there on this site? How many pagehits? What database are you using? (SQL Server 7.0 I guess) I can see that you are using IIS 5.0... Are the webserver and database server on the same hardware-box? What kind of hardware runs the database server (processors, ram, disks, raid)? How big is the database-file? I mean, I have been working with databases for several years, and I have seen queries that took almost 30 seconds to execute, but when we optimized the SQL code, they executed in under 1 second... No offence, really, I have a great respect for you guys, it's just that I know my way around SQL Server, and don't see why it's so slow... Lately Chriss was talking about a Serverfarm, a database cluster and that kinda stuff, but I guess you haven't implemented it yet... - Anders
Hey Anders, Chris has added a site description to the about page. Here's a quick link: http://www.codeproject.com/info/about.asp David
-
I don't know, did you not see the fact that I put a smiley in there to indicate it was a joke (and explicitly qualified it afterwards?) Why do you try to take a comment out of it's context and attempt to portray it as something else?
> did you not see the fact that I put a smiley in there to indicate it was a joke > (and explicitly qualified it afterwards?) Why do you try to take a comment > out of it's context and attempt to portray it as something else? That seems to happen a LOT around here... :( Peace! -=- James.