big-tables-mysql-SunOS_5.7_sun4m 859 Bytes
Newer Older
1
Testing server 'MySQL 3.23.29 gamma' at 2000-12-17  1:01:22
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2 3 4 5 6 7

Testing of some unusual tables
All tests are done 1000 times with 1000 fields

Testing table with 1000 fields
Testing select * from table with 1 record
8
Time to select_many_fields(1000): 83 wallclock secs (25.25 usr 45.29 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
9 10

Testing select all_fields from table with 1 record
11
Time to select_many_fields(1000): 110 wallclock secs (26.77 usr 45.25 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
12 13

Testing insert VALUES()
14
Time to insert_many_fields(1000): 21 wallclock secs ( 2.97 usr  0.57 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
15 16

Testing insert (all_fields) VALUES()
17
Time to insert_many_fields(1000): 45 wallclock secs ( 0.51 usr  0.50 sys +  0.00 cusr  0.00 csys =  0.00 CPU)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
18

19
Total time: 260 wallclock secs (55.55 usr 91.62 sys +  0.00 cusr  0.00 csys =  0.00 CPU)