Testing server 'MySQL 3.22.5 alpha' at 1998-08-22  0:05:37

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): 51 secs ( 8.67 usr  3.49 sys = 12.16 cpu)

Testing big selects on the table
Time for select_big (70:17207): 17 secs ( 2.26 usr  1.66 sys =  3.92 cpu)
Note: Query took longer then time-limit: 600
Estimating end time based on:
123 queries in 3 loops of 10 loops took 795 seconds
Estimated time for select_range (410:334594): 2650 secs (149.40 usr 102.77 sys = 252.17 cpu)
Note: Query took longer then time-limit: 600
Estimating end time based on:
20825 queries in 2975 loops of 10000 loops took 601 seconds
Estimated time for min_max_on_key (70000): 2020 secs (246.99 usr 69.45 sys = 316.44 cpu)
Note: Query took longer then time-limit: 600
Estimating end time based on:
2810 queries in 562 loops of 10000 loops took 601 seconds
Estimated time for count_on_key (50000): 10693 secs (197.69 usr 48.22 sys = 245.91 cpu)

Estimated total time: 15432 secs (605.01 usr 225.60 sys = 830.61 cpu)