On Tuesday 14 September 2004 15:26, Jason Louie wrote: > Hey gang, I'm currently running a debian server and finally had some > time to pull out some of my PHP projects. Using the same scripts that > I knew worked before I created the required permissions and databases. > However the pages now take an insane amount of time to load. Looking > into the matter the slowing down seems to be in the database access.
Which section of the database access? connection, query execution, data retreival? It could be any number of those. Or a combination. Hard to say. > The database is fine, (running the queries directly are > instantanious,) the PHP code seems fast. Loading pages without > database access is pretty quick. I'm using adodb as I did before, and > the same machine... the ONLY diffrence is that it is on a diffrent I am assuming that you are using MySQL then? :-( Have you tried regular MySQL routines (withour ADODB). Just to verify it is the ADO extraction, and not just your mysql settings. > distro. Any ideas on how I can speed this up? It takes 10 - 20 > seconds per query and for pages that require 5 - 10 queries the pages > don't load at all. > That is because by default you script execution time is probably set to 30 seconds and then the scripts dies. > I've since updated the adodb module and have upgraded php4. I would investigate into you php.ini settings for mysql. And maybe some general settings as well. I think this needs some more investigation though. Some more details are needed I would think. Different distro -> different settings. HTH, Andy _______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
