BBSˮľÇ廪վ¡Ã¾«»ªÇø
·¢ÐÅÈË: Persi (Ã÷ÔÂÌìÑÄ), ÐÅÇø: Linux
±ê Ìâ: postgreSQLÐÔÄܲâÊÔ (תÔØ)
·¢ÐÅÕ¾: BBS ˮľÇ廪վ (Sun Apr 4 20:43:06 1999)
¡¾ ÒÔÏÂÎÄ×ÖתÔØ×Ô Database ÌÖÂÛÇø ¡¿
¡¾ ÔÎÄÓÉ Persi Ëù·¢±í ¡¿
Ó²¼þÌõ¼þ£ºPentium 100, 32MÄÚ´æ, 64M swap
ÈçºÎ½âÊÍÒÔÏÂÊý¾Ý£¿
»¹Ó¦¸ÃÔö¼ÓʲôÑùµÄSelectÌõ¼þÒÔ·´Ó¦postgreSQLµÄ²éѯËÙ¶ÈÐÔÄÜ£¿
´ÓÏÂÃæµÄÊý¾Ý¿´postgreSQLµÄ²éѯËÙ¶ÈÐÔÄÜÈçºÎ£¿£¨±ÈÈçºÍoracle,mySQLµÈ
´óÖÐÐÍÊý¾Ý¿â±È½Ï£©
ÆäÖУ¬±íenterprise 56811Ìõ¼Ç¼£¬product±í110769Ìõ£¬¶¼ÔÚ
codeÊôÐÔÉϽ¨Á¢ÁËÒ»¸öË÷Òý¡££¨Ö÷¼ü£©
¿==========================
Command: select name from enterprise
Start At : Sun Apr 4 20:11:54 CST 1999
End At : Sun Apr 4 20:12:28 CST 1999
Time used(s): 34
(56811 rows)
-------------------------
==========================
Command: select code from enterprise
Start At : Sun Apr 4 20:12:29 CST 1999
End At : Sun Apr 4 20:12:59 CST 1999
Time used(s): 30
(56811 rows)
-------------------------
==========================
Command: select count(name) from enterprise
Start At : Sun Apr 4 20:13:00 CST 1999
End At : Sun Apr 4 20:13:24 CST 1999
Time used(s): 24
(1 row)
-------------------------
==========================
Command: select count(code) from enterprise
Start At : Sun Apr 4 20:13:25 CST 1999
End At : Sun Apr 4 20:13:49 CST 1999
Time used(s): 24
(1 row)
-------------------------
==========================
Command: select code from enterprise where code='100 '
Start At : Sun Apr 4 20:13:50 CST 1999
End At : Sun Apr 4 20:13:51 CST 1999
Time used(s): 1
(1 row)
-------------------------
==========================
Command: select code from enterprise where name='100 '
Start At : Sun Apr 4 20:13:51 CST 1999
End At : Sun Apr 4 20:14:14 CST 1999
Time used(s): 23
(0 rows)
-------------------------
==========================
Command: select code from enterprise where code like '100 '
Start At : Sun Apr 4 20:14:15 CST 1999
End At : Sun Apr 4 20:14:39 CST 1999
Time used(s): 24
(1 row)
-------------------------
==========================
Command: select code from enterprise where name like '100 '
Start At : Sun Apr 4 20:14:40 CST 1999
End At : Sun Apr 4 20:15:04 CST 1999
Time used(s): 24
(0 rows)
-------------------------
==========================
Command: select code from enterprise where code like '100%'
Start At : Sun Apr 4 20:15:05 CST 1999
End At : Sun Apr 4 20:15:29 CST 1999
Time used(s): 24
(111 rows)
-------------------------
==========================
Command: select code from enterprise where name like '100%'
Start At : Sun Apr 4 20:15:30 CST 1999
End At : Sun Apr 4 20:15:54 CST 1999
Time used(s): 24
(0 rows)
-------------------------
==========================
Command: select code from enterprise where code like '%100%'
Start At : Sun Apr 4 20:15:56 CST 1999
End At : Sun Apr 4 20:16:20 CST 1999
Time used(s): 24
(217 rows)
-------------------------
==========================
Command: select code from enterprise where code like '%100%' and name not like '
%100%'
Start At : Sun Apr 4 20:22:55 CST 1999
End At : Sun Apr 4 20:23:19 CST 1999
Time used(s): 25
(217 rows)
-------------------------
==========================
Command: select name from product
Start At : Sun Apr 4 20:27:45 CST 1999
End At : Sun Apr 4 20:28:58 CST 1999
Time used(s): 73
(110769 rows)
-------------------------
==========================
Command: select code from product
Start At : Sun Apr 4 20:28:59 CST 1999
End At : Sun Apr 4 20:30:01 CST 1999
Time used(s): 62
(110769 rows)
-------------------------
==========================
Command: select count(name) from product
Start At : Sun Apr 4 20:30:02 CST 1999
End At : Sun Apr 4 20:30:51 CST 1999
Time used(s): 49
(1 row)
-------------------------
==========================
Command: select count(code) from product
Start At : Sun Apr 4 20:30:52 CST 1999
End At : Sun Apr 4 20:31:40 CST 1999
Time used(s): 48
(1 row)
-------------------------
==========================
Command: select code from product where code='100 '
Start At : Sun Apr 4 20:31:41 CST 1999
End At : Sun Apr 4 20:31:42 CST 1999
Time used(s): 1
(1 row)
-------------------------
==========================
Command: select code from product where name='100 '
Start At : Sun Apr 4 20:31:43 CST 1999
End At : Sun Apr 4 20:32:28 CST 1999
Time used(s): 45
(0 rows)
-------------------------
==========================
Command: select code from product where code like '100 '
Start At : Sun Apr 4 20:32:28 CST 1999
End At : Sun Apr 4 20:33:18 CST 1999
Time used(s): 50
(1 row)
-------------------------
==========================
Command: select code from product where name like '100 '
Start At : Sun Apr 4 20:33:18 CST 1999
End At : Sun Apr 4 20:34:08 CST 1999
Time used(s): 50
(0 rows)
-------------------------
==========================
Command: select code from product where code like '100%'
Start At : Sun Apr 4 20:34:09 CST 1999
End At : Sun Apr 4 20:34:58 CST 1999
Time used(s): 49
(1111 rows)
-------------------------
==========================
Command: select code from product where name like '100%'
Start At : Sun Apr 4 20:34:58 CST 1999
End At : Sun Apr 4 20:35:48 CST 1999
Time used(s): 50
(13 rows)
-------------------------
==========================
Command: select code from product where code like '%100%'
Start At : Sun Apr 4 20:35:49 CST 1999
End At : Sun Apr 4 20:36:38 CST 1999
Time used(s): 49
(1420 rows)
-------------------------
==========================
Command: select code from product where code like '%100%' and name not like '%10
0%'
Start At : Sun Apr 4 20:36:38 CST 1999
End At : Sun Apr 4 20:37:27 CST 1999
Time used(s): 50
(1420 rows)
-------------------------
--
¡ù À´Ô´:¡¤BBS ˮľÇ廪վ bbs.net.tsinghua.edu.cn¡¤[FROM: venus.ihip.pku.]
BBSˮľÇ廪վ¡Ã¾«»ªÇø