in reply to Speeding up the DBI
I found a nice article here.
Basically, you want large sets not in an arrayref, but as a hash, since it's more clear what column holds the data.
e.g.
Hmm, Funny indeed, anyway, i still consider this as a valuable way to speed up the DBI. :-)
Basically, you want large sets not in an arrayref, but as a hash, since it's more clear what column holds the data.
e.g.
*Update*# tested this on live data, this is twice as fast as fetchrow_hashref, + and has the same advantage.. # example taken from the link above. my @fields = (qw(emp_id first_name monthly_payment)); $sth->execute; my %rec =(); $sth->bind_columns(map {\$rec{$_}} @fields); print "$rec{emp_id}\t", "$rec{first_name}\t", "$rec{monthly_payment}\n" while $sth->fetchrow_arrayref;
Hmm, Funny indeed, anyway, i still consider this as a valuable way to speed up the DBI. :-)
"We all agree on the necessity of compromise. We just can't agree on when it's necessary to compromise." - Larry Wall.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Speeding up the DBI
by cchampion (Curate) on Jun 09, 2005 at 10:22 UTC |
In Section
Meditations