Select Code to Download

#        $n % 10 or $dbh->commit

C:\test>1049236 -N=1e6 -T=1 -Qsize=1000
Took 86.039947 seconds (for Populate DB with 1e6 records)
...
Took 16.881054 seconds (for Retrieve the whole lot)
1000000
Took 0.251258 seconds (for Read all 1e6 records using 4 threads)

C:\test>1049236 -N=1e6 -T=1 -Qsize=1000
Took 86.307525 seconds (for Populate DB with 1e6 records)
...
Took 3.017540 seconds (for Create primary index)
1000000
Took 1.925757 seconds (for Read all 1e6 records using 4 threads)