Testing server 'MySQL 3.22.0 alpha' at 1998-05-18 4:01:03 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): 14 secs ( 3.21 usr 1.33 sys = 4.54 cpu) Testing big selects on the table Time for select_big (70:17207): 2 secs ( 0.39 usr 0.07 sys = 0.46 cpu) Note: The query took longer then time-limit: 600; Estimating end time based on: 328 queries in 8 loops of 10 loops took 614 seconds Estimated time for select_range (410:838350): 767 secs (23.34 usr 3.71 sys = 27.05 cpu) Estimated total time: 783 secs (26.94 usr 5.11 sys = 32.05 cpu)