Did you debug the code? RE: Yes. Problem only occurs with large data set. Throw in some timers? RE: What would we be timing. Run some stats on your queries? RE: Explain plan on queries look good. I do not think that any of the process timeouts will do anything for you, but I think you already found that out. What have you done on the oracle side to test this? RE: Queries run fine from sqlplus. Explain plans analyzed. Is the root of the problem: It takes too long to get html? RE: Yes. When data set is large, only the first html data up to the end of the first <form> tag is returned. (debug statements are also returned). Then the next echo "<br>..." statement does not return - again only on large data set. On smaller data set, all the stuff comes back. -OR- It does not return any html? RE: No, only part of page is returned on large data set. On smaller data set, all is returned. In either case, logic points to either database query bottlenecks, OR looping queries. In which case, have you monitored your apache server as the page is being requested? RE: Yes, entry in access log sometimes takes a long time to come up, when query is stopped on browser client and resubmitted. Is RAM/Proc normal during the request? RE: Top shows ok. There is a remote possibility that something is out of whack in the php code. It is highly doubtful that apache is involved. RE: I wouldn't count that out. Question is what could it be? Apache Timeout used to be a factor in large data sets. Doesn't appear to be now, though am not sure - it's set to 6000 now. Charlie 8/18/05 6:53 a.m. MST -----Original Message----- From: Charlie Smith Sent: Wednesday, August 17, 2005 9:07 AM To:Tim Burden and apache users. Subject: Re: [users@httpd] Strange qustion - how to prevent apache delay? I removed the OT from the subject line, as I'm not convinced. What else would keep Apache from putting entry in log file for accessing the php script? Rather from taking so long to put the call in the access log? Turning up the Apache Timeout var did not work. Script is not eventually returning normally. It is as if it stops half way through and client never gets html back from cgi script that is supposed to. So, maybe turning up max_execution_time would work? Charlie --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx ------------------------------------------------------------------------------ This message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed. ------------------------------------------------------------------------------ --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|