PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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