atis-mysql-nt_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase

来自「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-al」· 0-CMP-DB2,INFORMIX,MS-SQL,MYSQL,ORACLE,SOLID,SYBASE 代码 · 共 20 行

Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:53:01

ATIS table test

Creating tables
Time for create_table (28):  0 wallclock secs ( 0.00 usr +  0.01 sys =  0.01 CPU)

Inserting data
Time to insert (9768):  8 wallclock secs ( 1.66 usr +  1.41 sys =  3.07 CPU)

Retrieving data
Time for select_simple_join (500):  3 wallclock secs ( 1.23 usr +  0.50 sys =  1.73 CPU)
Time for select_join (200): 31 wallclock secs ( 8.80 usr +  4.19 sys = 12.99 CPU)
Time for select_distinct (800): 17 wallclock secs ( 3.22 usr +  1.51 sys =  4.74 CPU)
Time for select_group (2100): 12 wallclock secs ( 1.95 usr +  0.58 sys =  2.53 CPU)

Removing tables
Time to drop_table (28):  0 wallclock secs ( 0.00 usr +  0.02 sys =  0.02 CPU)
Total time: 71 wallclock secs (16.88 usr +  8.22 sys = 25.11 CPU)