Select Code to Download

# insert and write performance
print "Begin insertions...\n\n";
...
$dbh->do( qq[ SET FOREIGN_KEY_CHECKS=1 ] );
$dbh->commit();
$dbh->disconnect();

[insert]         [date time]   [ins/s]
     1000 2005-03-08 16:02:23  1053.265
...
     8000 2005-03-08 16:02:54   142.633
     9000 2005-03-08 16:03:02   126.241
    10000 2005-03-08 16:03:10   114.398

0: 587.5440658049354 ins/s
1000: 1117.31843575419 ins/s
...
8000: 2188.1838074398247 ins/s
9000: 2066.115702479339 ins/s
10000: 2314.814814814815 ins/s

[#insert]         [date time]   [ins/s]
     1000 2005-03-08 16:32:06  1109.196
...
     8000 2005-03-08 16:32:38   137.563
     9000 2005-03-08 16:32:47   110.940
    10000 2005-03-08 16:32:59    82.182