big-tables-pg_fast-linux_2.0.36_i686-cmp-mysql,pg,solid

来自「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-al」· 36_I686-CMP-MYSQL,PG,SOLID 代码 · 共 26 行

Testing server 'PostgreSQL 6.4' at 1999-03-11  7:25:22

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

Testing table with 300 fields
Time for book-keeping (1):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Testing select * from table with 1 record
Time to select_many_fields(1000): 150 wallclock secs ( 2.78 usr  0.29 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Testing select all_fields from table with 1 record
Time to select_many_fields(1000): 158 wallclock secs ( 3.24 usr  0.23 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Testing insert VALUES()
Time to insert_many_fields(1000): 51 wallclock secs ( 0.60 usr  0.07 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Time for book-keeping (1):  1 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Testing insert (all_fields) VALUES()
Time to insert_many_fields(1000): 69 wallclock secs ( 0.86 usr  0.05 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Time for book-keeping (1):  0 wallclock secs ( 0.00 usr  0.00 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)

Total time: 430 wallclock secs ( 7.48 usr  0.64 sys +  0.00 cusr  0.00 csys =  0.00 CPU secs)