Testing server 'MySQL 3.21.29-gamma' at 1998-04-21 12:45:09

Testing the speed of selecting on keys that consist of many parts
The test-table has 10000 rows and the test is done with 40 ranges.

Creating table
Inserting 10000 rows
Time to insert (10000): 15 secs ( 3.52 usr  0.56 sys =  4.08 cpu)

Testing big selects on the table
Time for select_big (70:17207):  2 secs ( 0.44 usr  0.15 sys =  0.59 cpu)
Time for select_range (410:214316): 29 secs ( 5.57 usr  1.44 sys =  7.01 cpu)
Total time: 47 secs ( 9.54 usr  2.16 sys = 11.70 cpu)