Testing server 'MySQL 3.22.0-gamma' at 1998-04-29 21:49:46

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

Creating table
Inserting 10000 rows
Time to insert (10000): 13 secs ( 3.15 usr  0.78 sys =  3.93 cpu)

Testing big selects on the table
Time for select_big (70:17207):  2 secs ( 0.44 usr  0.10 sys =  0.54 cpu)
Note: The query took longer then time-limit: 600; Estimating end time based on:
369 queries in 9 loops of 10 loops took 647 seconds
Estimated time for select_range (410:956467): 718 secs (26.17 usr  7.51 sys = 33.68 cpu)
Estimated total time: 733 secs (29.78 usr  8.39 sys = 38.17 cpu)