Becky,
> Here is the EXPLAIN output from the two queries. The first is the one
> that uses WHERE field NOT IN ( 'a','b' etc ). The second is the (much
> faster) one
> that uses WHERE NOT (field = 'a' and field = 'b' etc).
We still can't help you if you're not posting your actual queries. We have no
idea what's in query3.sql. We're not clairvoyant, y'know.
--
Josh Berkus
Aglio Database Solutions
San Francisco