Testing server 'MySQL 3.21.29-gamma' at 1998-04-08 12:36:04

Testing the speed of selecting on keys that consist of many parts
The tests are done with a table that has 10000 rows.

Creating table
Inserting 10000 rows
Time to insert (10000): 14 secs ( 3.93 usr  0.79 sys =  4.72 cpu)

Testing big selects on the table
Time for select_big (70):  2 secs ( 0.51 usr  0.19 sys =  0.70 cpu)
Note: The query took longer then time-limit: 600; Estimating end time based on:
287 queries in 7 loops of 10 loops took 629 seconds
Estimated time for select_range (410): 898 secs (32.46 usr  9.34 sys = 41.80 cpu)
Estimated total time: 914 secs (36.90 usr 10.32 sys = 47.22 cpu)