Testing server 'MySQL 3.22.0 alpha' at 1998-05-18 14:48:44

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): 12 secs ( 3.09 usr  0.58 sys =  3.67 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 662 seconds
Estimated time for select_range (410:956467): 735 secs (25.82 usr  7.90 sys = 33.72 cpu)
Estimated total time: 749 secs (29.36 usr  8.59 sys = 37.95 cpu)