Amazingly the solution came to me while driving to work today. Somehow I had the feeling that the server resolution might be the cause... so I got to work and noticed that the hosts files was missing. So added localhost to ip 127.0.0.1 and everything is good.
On Tue, 14 Sep 2004 18:17:13 -0600, Andrew J. Kopciuch <[EMAIL PROTECTED]> wrote: > 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
