I was just ranting about this customer in this thread.
I start checking out their logs and noticed slashdot.org as the referer *gulp*. We had a site go through a slashdotting a year ago. The site was written in ColdFusion and used Access as the back end!!! The site (and the server) managed to handle the 1.5 million hits in 2 hours.
The site in question today (linky) is written in ASP and uses MS SQL Server as the backend. Too bad the site has the worst DB coding I've ever seend! There are (SELECT *) queries in loops! One request to the page that is having a tough time handling the load does around 50 queries per request!
I've contacted the developer and he said he will try to fix it, but wasn't sure where to start. I don't want to shut down his site, because
it isn't killing the server too bad though... every other site on the server is responding well even though the CPU load is 100%.
Before you go an blame your web-host about downtime, think about how many poor coders there are out there, and the odds that
one of them happens to be on the same server as your website
. Albeit, I do try my best to help out said poor coders, but there are
too many of them!
I start checking out their logs and noticed slashdot.org as the referer *gulp*. We had a site go through a slashdotting a year ago. The site was written in ColdFusion and used Access as the back end!!! The site (and the server) managed to handle the 1.5 million hits in 2 hours.
The site in question today (linky) is written in ASP and uses MS SQL Server as the backend. Too bad the site has the worst DB coding I've ever seend! There are (SELECT *) queries in loops! One request to the page that is having a tough time handling the load does around 50 queries per request!
I've contacted the developer and he said he will try to fix it, but wasn't sure where to start. I don't want to shut down his site, because
it isn't killing the server too bad though... every other site on the server is responding well even though the CPU load is 100%.
Before you go an blame your web-host about downtime, think about how many poor coders there are out there, and the odds that
one of them happens to be on the same server as your website
. Albeit, I do try my best to help out said poor coders, but there aretoo many of them!
Facebook
Twitter