I've had tens of thousands of items in an "IN" list without failure, but it seems that when you get that many it takes a very long time to parse.
The speed thing bothers me, so I'm toying with a new design, but it's a big enough system that it's slow going. J -----Original Message----- From: Batara Kesuma [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 4:00 AM To: [EMAIL PROTECTED] Subject: Very big IN ( $value ) Hi, I do my query from Perl DBI, it has a very big IN ( $value ). The query looks like: SELECT id FROM user WHERE sex='m' AND hobby_id='3' AND id IN ( $value ); $value looks like: 102, 233, 445, 543 ... 3443, 332 very long list. It might be about 10,000 id in $value. What is the maximum value I can pass in a query? Is this the right way to do it? (I mean, using a very big value inside IN) Thank you, --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
