On 16-Apr-2002 Alexander Hartmaier wrote: > I just reworte view-table.epl...it isn't faster than before.... > > Here is the new version (the display of the number of lines isn't workling > any more :( > Maybe you can tell me what i do false:
Hmmm... 1. I'm unsure whether it's good to use eval around so much code... is it the most efficient method? You could wrap it just around the ->prepare and ->execute. Actually, you don't eval at all. The critical DBI method calls return true or false, which you can catch: $sth = $dbh->prepare($sqlcmd) || perish ($dbh->errstr); $sth->execute || perish ($dbh->errstr); Something to experiment with perhaps. 2. Are you able to pinpoint the slow down? E.g. Add statements like: warn "here at: " . `date`; To add warn statements into the error_log of where it's at. I've use this trick quite often. Add one at the very top of the file, one after setting up $dbh, one before executing, one after executing, one before fetching rows, one after fetching rows, etc. 3. See what the Embperl docs say about the various debug modes; you should be able to get a lot more verbose embperl.log debbuging then what your previous attachment had. Regards, Wim Kerkhoff -|- www.nyetwork.org -|- [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
