MySQL Forums
Forum List  »  Performance

Limit for looping ANDs to a query
Posted by: Matti Niemela
Date: February 01, 2005 04:12PM

Hi!

Is there any limit to how many " AND field = 'value' " -statements (or whatever those are) I can have in a mysql query before it affects performance at a noticable level? Ten? Fifty? A hundred? Two hundred?

So my query would look like this depending how many times I need to loop it:
SELECT field FROM table WHERE field = 'value1' AND field = 'value2' AND field = 'value3' AND field = 'value4' AND field = 'value5' AND field = 'value6' AND field = 'value7' AND field = 'value8' AND field = 'value9' ............... LIMIT 1

Options: ReplyQuote


Subject
Views
Written By
Posted
Limit for looping ANDs to a query
2499
February 01, 2005 04:12PM
1839
February 04, 2005 12:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.