sql语句效率比较

发布:2011-07-22 09:00   点击1105次   评论:0

0: 3.87,4.22,3.84    catid in(SELECT catid FROM dzx_portal_category WHERE upid=''9'')
1: 0.82,0.86,0.80    catid in(''56'',''57'',''58'')
2: 0.87,0.85,0.86    (catid=56 Or catid=57 Or catid=58) [否定,代码太多,效率也不一定高]
3: 0.84,0.94,0.93    catid in(56,57,58)
4: 0.85,0.83,0.82    catid>55 AND catid<59 [否定,不一定连续]

------------------------------------------------------------

0.8x catid in(''56'',''57'',''58'')
4.xx catid in(SELECT catid FROM dzx_portal_category WHERE upid=''9'')

关于 GitHub 导航 部门 反馈

提示:`/home.php`入口数据仅为演示功能,不构成任何交易凭证,也不承担相关风险和责任!

Copyright © 2011-2018 xxxxx.com All rights reserved.

Run:14.224/55.336(ms); 7(sql)/2.875(MB); comm:news/detail; Upd:2025-01-11 10:46:47