Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause, even when the matching
field is indexed.
Is this something that buffer
On Thu, 30 Oct 2003 15:48:05 -0700, Knepley, Jim [EMAIL PROTECTED] wrote:
Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause,
values).
If you're using MySQL 3.23, I've noticed that the query parser seems
much, much faster in 4.0.
Matt
- Original Message -
From: Knepley, Jim
Sent: Thursday, October 30, 2003 4:48 PM
Subject: WHERE IN performance
Is it anyone elses experience that queries with large IN stanzas
