Testing server 'MySQL 3.22.0 alpha' at 1998-05-18  3:41:33

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

Creating table
Inserting 10000 rows
Time to insert (10000): 12 secs ( 2.86 usr  0.65 sys =  3.51 cpu)

Testing big selects on the table
Time for select_big (70:17207):  2 secs ( 0.43 usr  0.12 sys =  0.55 cpu)
Time for select_range (400:788160): 491 secs (19.57 usr  5.60 sys = 25.17 cpu)
Total time: 505 secs (22.86 usr  6.37 sys = 29.23 cpu)