View Single Post
  #2 (permalink)  
Old 01-26-2008, 02:18 PM
Tech Manager Tech Manager is offline
WebProWorld Pro
 

Join Date: Jan 2008
Posts: 267
Tech Manager RepRank 1
Default Re: slow server respons because of too much database requests

You need to start by diagnosing the problem using some actual data. While I can assume SQL is the cause for you slowdown, this isn't necessarily true. Take a close look at your server logs and run some diagnostic tests that actually measure the slowdowns and provide you with a look at the programs that may be culprits.

SQL is often accused of causing problems that it did not cause. Sometimes it is bad database or query design. Sometimes it is lack of resources on the individual server. If the problem is SQL you may solve it by using a backend server or setting up load balancing.

In the interim examine all the variables and look at the appropriate diagnostic data to help with your troubleshooting.
__________________
I use Country IP Blocks as added security for my networks and servers.
Reply With Quote