ATIS-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- Testing server 'Oracle 8.0.5.0.0' at 1999-03-23 8:05:46
- ATIS table test
- Creating tables
- Time for create_table (28): 4 wallclock secs ( 0.04 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for book-keeping (1): 22 wallclock secs ( 0.05 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Inserting data
- Time to insert (9768): 46 wallclock secs ( 7.61 usr 0.91 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for book-keeping (1): 23 wallclock secs ( 0.07 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Retrieving data
- Time for select_simple_join (500): 20 wallclock secs ( 8.26 usr 1.90 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for select_join (200): 188 wallclock secs (71.78 usr 18.08 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for select_distinct (800): 56 wallclock secs (24.55 usr 5.45 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for select_group (2300): 29 wallclock secs (12.06 usr 2.85 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Removing tables
- Time to drop_table (28): 3 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Time for book-keeping (1): 3 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- Total time: 396 wallclock secs (124.50 usr 29.24 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)