sybperl-l Archive

From: SA Lim <salim at epax02 dot fairchildsemi dot com>
Subject: Hang up
Date: Oct 11 1999 9:17AM

Hi,

Every time our SA does a weekly maintenance of the database, my
CGI program which normally takes less than 10 seconds to return,
would timeout after 2 minutes at the following code. Is there any
way to re-write the code to prevent this?
I'm running Sybperl 2.09_04 on Solaris 2.6.

  $dbh->ct_execute("$sql_query");
  while ($dbh->ct_results($restype) == CS_SUCCEED) {
    next unless $dbh->ct_fetchable($restype);
    while (@row = $dbh->ct_fetch) {
     (do something)
    }
  }

TIA,
SA Lim