in reply to Re^2: ERROR on CGI script:The timeout specified has expired
in thread ERROR on CGI script:The timeout specified has expired

You can check the Apache "Timeout" directive. However, how long does it take to run the query in A SQL Console?

Are you sure that ur not generating a lot of STDERR output?

«A contentious debate is always associated with a lack of valid arguments.»
  • Comment on Re^3: ERROR on CGI script:The timeout specified has expired

Replies are listed 'Best First'.
Re^4: ERROR on CGI script:The timeout specified has expired
by Anonymous Monk on Nov 24, 2009 at 15:21 UTC
    Gulden, I am sure that, it's not generating STDERR (very few may be), I have already tried redirecting STDERR as per the bug report. About, the query ... query takes almost 7 minutes to complete in sql console. I am sure that, due to this long running query only it's getting expired. Thanks
[reply]
      7 Mins is one hell of a query time. A few thoughts occur
      • Which DBD ?
      • Could your data be re-organised/rationalised in such a way that there were fewer complex joins?
      • Could you re-organise your data so that you are only using one prinary key on each table.
      MySQL in particualr is faster if smaller queries are agregated than it is if asked to make complex JOINs (at least it was 5 years ago when last I used it).
[reply]

In Section Seekers of Perl Wisdom