Tokuview (http://blogs.tokutek.com/tokuview/iibench/) is building a test scripts/program for 1B record insert performance.
This is fine, but ultimately the logistics of the DB environment will dictate what ‘tricks’ can be pulled to insert records the fastest. Can you access raw MyISAM files or not? Are you running concurrent inserts? Do you require ACID compliance?
There are 3 basic techniques I’ve found for inserting records into a MyISAM DB table are: