Testing server 'MySQL 3.21.28-gamma' at 1998-04-06 15:22:41

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.85 usr  0.64 sys =  4.49 cpu)

Testing big selects on the table
Time for select_big (70):  3 secs ( 0.57 usr  0.11 sys =  0.68 cpu)
Note: The query took longer then time-limit: 600; Estimating end time based on:
246 queries in 6 loops of 10 loops took 629 seconds
Estimated time for select_range (410): 1048 secs (32.40 usr  8.85 sys = 41.25 cpu)
Estimated total time: 1065 secs (36.83 usr  9.60 sys = 46.43 cpu)