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.
|