Select Code to Download

use strict;
use warnings;
...
   
    my $r = $h->selectall_arrayref(q/select * from benchtest/);
}

Benchmark: timing 10 iterations of odbcinsert, oracleinsert...
odbcinsert: 54 wallclock secs ( 1.46 usr +  0.64 sys =  2.10 CPU) @  4
+.76/s (n=10)
...
Benchmark: timing 10 iterations of odbcselect, oracleselect...
odbcselect: 10 wallclock secs ( 4.70 usr +  0.17 sys =  4.87 CPU) @  2
+.05/s (n=10)
oracleselect: 10 wallclock secs ( 5.14 usr +  0.01 sys =  5.15 CPU) @ 
+ 1.94/s (n=10)