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

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
  • Comment on Re^4: ERROR on CGI script:The timeout specified has expired

Replies are listed 'Best First'.
Re^5: ERROR on CGI script:The timeout specified has expired
by Utilitarian (Vicar) on Nov 24, 2009 at 15:35 UTC
    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