Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay?

2005-08-17 Thread Charlie Smith
ipts are eventually returning normally. Don't know anything about Oracle. This is now completely OT, nothing to do with Apache. - Original Message - From: "Charlie Smith" Sent: Tuesday, August 16, 2005 4:20 PM Subject: Re: [EMAIL PROTECTED] [OT] Strange qustion - how to preven

Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay?

2005-08-16 Thread Charlie Smith
know anything about Oracle. This is now completely OT, nothing to do with Apache. - Original Message - From: "Charlie Smith" Sent: Tuesday, August 16, 2005 4:20 PM Subject: Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay? > Perhaps turning up max_exec

Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay?

2005-08-16 Thread Tim Burden
t;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Tuesday, August 16, 2005 4:20 PM Subject: Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay? > Perhaps turning up max_execution_time As script sometimes does take over 5 > minutes to actually > return da

Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay?

2005-08-16 Thread Charlie Smith
Perhaps turning up max_execution_time As script sometimes does take over 5 minutes to actually return data? We can expect some of the queries to actually take longer that 10 seconds. Also, am using Oracle as db rather than MySQL. max_execution_time = 30 ; Maximum execution time of each scri

Re: [EMAIL PROTECTED] [OT] Strange qustion - how to prevent apache delay?

2005-08-16 Thread Tim Burden
This is off-topic, but in my experience this is almost always a problem with queries that are taking too long to process. You can turn on the MySQL slow query log to try to determine this, but often the quick answer is to double-check that you have proper indexes on any field used in a WHERE clause