Select Code to Download

Benchmark: timing 500 iterations of dbh_insert, dbh_insert_values, sth
+_insert...
dbh_insert: 28 wallclock secs ( 5.99 usr +  1.68 sys =  7.67 CPU) @ 65
+.19/s (n=500)
dbh_insert_values: 27 wallclock secs ( 6.02 usr +  1.82 sys =  7.84 CP
+U) @ 63.78/s (n=500)
sth_insert: 59 wallclock secs (28.48 usr +  2.41 sys = 30.89 CPU) @ 16
+.19/s (n=500)

Benchmark: timing 500 iterations of dbh_insert, dbh_insert_values, sth
+_insert...
dbh_insert: 20 wallclock secs ( 5.30 usr +  1.41 sys =  6.71 CPU) @ 74
+.52/s (n=500)
dbh_insert_values: 23 wallclock secs ( 5.62 usr +  1.45 sys =  7.07 CP
+U) @ 70.72/s (n=500)
sth_insert: 55 wallclock secs (27.53 usr +  2.50 sys = 30.03 CPU) @ 16
+.65/s (n=500)

sub insert_flatfile {
        # Note: files opened in > mode again to prevent disk space iss
+ues
...
        }
        close(FF);
}

sub insert_flatfile {
        # Note: files opened in > mode again to prevent disk space iss
+ues
...
        }

}

insert into table (blah,blah2,blah3) values ('vbla1','vbla2','vbla3'),
('vbla1b','vbla2b','vbla3b'),
ect...

Benchmark: timing 500 iterations of Flatfile_Insert, Mysql_Insert...
Flatfile_Insert:  8 wallclock secs ( 4.29 usr +  3.30 sys =  7.59 CPU)
+ @ 65.88/s (n=500)
...
            (warning: too few iterations for a reliable count)
Mysql_Delete:  0 wallclock secs ( 0.00 usr +  0.00 sys =  0.00 CPU)
            (warning: too few iterations for a reliable count)

Benchmark: timing 500 iterations of Flatfile_Insert, Mysql_Insert...
Flatfile_Insert:  8 wallclock secs ( 4.02 usr +  3.36 sys =  7.38 CPU)
+ @ 67.75/s (n=500)
...
Mysql_Delete:  0 wallclock secs ( 0.01 usr +  0.01 sys =  0.02 CPU) @ 
+50.00/s (n=1)
            (warning: too few iterations for a reliable count)