in reply to Re^2: DBI Hash of Column name values
in thread DBI Hash of Column name values

Interesting ... YMMV most definitely. Not sure if it's due to a difference in the databases, or the drivers or the data itself ... but using your approach against a 43 col table (mixed data types), I get: 

slice:  14021.59 recs/sec
bind:    6750.10 recs/sec

[download]

-derby

Replies are listed 'Best First'.
Re^4: DBI Hash of Column name values
by Tux (Canon) on Aug 10, 2010 at 13:52 UTC

    For the local compare, where bind was twice as fast as slice, I used:

    Linux    2.6.31.12-0.2 x86_64
CPU      Core(TM) i5 CPU 660 @ 3.33GHz/1199(2)
Memory   7802 Mb
perl     5.12.1 64bitall/longdouble
DBI      1.613
DBD::Pg  2.17.1
Postgres 8.4.4

    [download]

    Enjoy, Have FUN! H.Merijn
[reply]
[d/l]

In Section Seekers of Perl Wisdom