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.
In my experience, large IN clauses are considered inadviseable in any RDBMS. In all my uses we have designed databases and queries to avoid this sort of situation, Oracle or MySQL.
-bluejack
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]