As said above
For instance WHERE In(var 1,var 2,var 3, ..., var 5609,)
Any limits before it slows the machine down ?
views:
66answers:
6
A:
With "limits", are you referring to a limitation in the the implementation, or something that will slow the query down? If it's the latter, the best answer is test it yourself.
Evan Trimboli
2010-06-21 04:53:32
Sorry for being vague. I am just asking if a few thousand numbers inside the in statement is too much and will bring the server to a halt :)
Matt
2010-06-21 04:55:14
You could possibly try inserting that data into a temp table first.
Graphain
2010-06-21 04:59:39
+1
A:
In Oracle (Verified only in 10g) it is 1000.
ORA-01795: maximum number of expressions in a list is 1000
Sujee
2010-06-21 05:00:58
+1
A:
I don't believe there is a limit to the number of values in the list of the IN clause in MySQL, unlike the 1000 Oracle limit. I would verify this though by writing some sort of loop to build a really long 'IN' statement if you had a concern. Also, someone else asked this question and there wasn't a known limit.
thekaido
2010-06-21 05:06:08
A:
MS SQL Server chokes at around 2000, MS SQL Compact has no limits (or I have not reached it yet, more than 2500).
Note: these are limits on parameters for queries.
leppie
2010-06-21 05:14:08
+1
A:
I would say that if you have to ask then you're probably doing something wrong. :)
Qberticus
2010-06-21 05:15:30