in reply to Efficiency

I see that you're using fetchrow_hashref, so I will point out the following caveat from the DBI documentation:
fetchrow_hashref ... Because of the extra work fetchrow_hashref and Perl have to perform, it is not as efficient as fetchrow_arrayref or fetchrow_array.
Of course, if you switch to fetchrow_array or fetchrow_arrayref, you will have to be careful about the order of the column names in the SELECT statement, but I think it's worth it if you want to improve efficiency.

Replies are listed 'Best First'.
Re: Re: Efficiency
by tekniko (Deacon) on Dec 22, 2000 at 23:05 UTC
    Ah...Excellent! It's a fairly uninvolved database with not many fields, but lots of records. Customers rely pretty heavily on stats and get cranky when they break.