On Sunday 20 January 2002 16:56, Francisco Reyes wrote: > On Sat, 19 Jan 2002, Chadwick Rolfs wrote: > > On Sat, 19 Jan 2002, Francisco Reyes wrote: > > > New to the PHP/PostgreSQL combo. > > > I have a couple of queries which take a few minutes to run and we are > > > getting timeouts. Didn't find anything usefull on the archives. > > > > > > How are you handling long running queries on your PHP? [...] > After someone suggested I looked at "set_time_limit" I found that such > function doesn't account for DBconnection time. Afer reading that and your > suggestion to read httpd.conf I am starting to think that the likely place > of the timeout is the web server. > > Will play with the settings on httpd.conf > > I wonder how sites that display an update while the long query is running > do it. I have seen sites that display something like "retrieving info.. > please wait" and then right before the info comes up the waiting text > dissapears. Is that Javascript? Flash? I can't imagine how that could be > done with plain html. What timeout message do you get, exactly? I could be just the *client*, or the HTTP proxy, that times out if your script doesn't produce any output, and *not* the httpd process (thus, no need to look at httpd.conf). .TM.
