Diminishing returns, Intensity.
You reach a point where it takes so long for a query to run, and so long to process it that you end up with things queued up behind it. The more you have in queue the higher the load on the server and then the longer things take to run, which makes the queue longer.
If you can get in and out of the database faster, proccess the information and get it to the user faster you're better off doing that then you are using longer running queries/insert/updates creating a waiting queue and/or holding tables locked longer. Especially in a high traffic high volume situation.
I'm wondering... if dreamhost would rather you not make continual new connections will they allow you to use the pconnect function? It would seem to get around thier issue of making new connections quite nicely and can be enabled right in the control panel.
Speaking as a web host I know I disagree with them. I don't want any long running connections. They queue, slow things down, and you run out of connections. I'd prefer you to get in, run the query and get out. The connection pool is limited, so the faster they move in and out the better..
Last edited by navaho; 12/05/2002 4:14 PM.
