Quote:
Originally posted by Aheib
You must remember that I opened, initialized, queried, stored and closed that mysql connection 2500 times.
It wasn't open once, request 2500 times the same data, and then close. I think that caused the difference for a considerable part.
|
Have to agree on this one. Opening a connection to mysql does take a good proportion of the query time, as does building an execution plan for the sql. Thought these can be overcome.
When used with mod_perl and Apache DBI (for persistent connections) it simply rocks. You can also cache your queries for further significant speed improvements..
Unfortunately I don't think many PHP trade scripts make use of these features
