Hello, I am trying to improve performance on some of the pages that utilize HTML::Template.
I believe my problem is in the way that I handle data from the db and transfer it to HTML::Template's param function. Here's what I mean: my $sql = qq{SELECT ...}; $sth = $dbh->prepare($sql) or bail_out($self); $sth->execute() or bail_out($self); push @{$catnames}, $_ while $_ = $sth->fetchrow_hashref(); $sth->finish(); $thtml->param(CATNAMES => \@{$catnames}); This can probably be done differently, since I am looping through every hash element. Any ideas? The site in question is http://www.exceltip.com/ - please be patient :) Thanks, Roy ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Html-template-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/html-template-users