一个query很多loop和一个heavy query

mylover

有个问题想请问for x=1; x<=1000; x++
select * from member where mid=x;
和
select * from member where mid IN (1,2,3...1000);

哪一个会比较快呢？
table是million row

兔仙人

SELECT * FROM TABLE WHERE mid BETWEEN 1 AND 1000

jasonmun

头一个将100改为1000才好比较吧..

mylover

ops是1000
打错

lebellebebe

use EXISTS instead of IN

ahbutt

select * from member where mid IN (1,2,3...1000);

如果in clause 太多，会stack overflow exception...

geekman

如此极品的IN clause，真的是第一次看到。。。

natadecoco86

为是么要Loop 1000 呢？既然你都是要用 number as key。除非你是一次只需要一row。不然，用 SELECT * FROM TABLE WHERE mid BETWEEN 1 AND 1000；会比较好。