in reply to Help required to improve code
Does the same thing you are already doing, but it is faster, easier to read, less room for error.while (my $row = $sth->fetchrow_hashref) { push @SearchResults, $row; }
In general though, your code is at the point where you need to work more on pushing the work down to Perl, factoring out common strings, etc. The biggest win is in readability, and maintainability, but generally performance will improve as well.
|
|---|