On 16-Apr-2002 Alexander Hartmaier wrote: > I tried for one week to change apache settings and other things but the thing > is damn slow! Almost 1 minute for the biggest table which has ~2100 lines > with 16 fields per line. > The httpd process on the "new" machine uses all available processor > ressources available for the whole time!
It could be something in 2.0b7, but seriously look at refactoring the code. Inside that eval block, the entire results of the query are being loaded into memory. Instead of doing that, only put the $dbh->prepare and $sth->execute in the eval. In the display code, process each row one at a time, via something like this: [$ while (@data = $sth->fetchrow) $] ... html to display table cells and links ... [$ endwhile $] Regards, Wim Kerkhoff -|- www.nyetwork.org -|- [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
