The IN and NOT IN searches (sub-queries) are not optimized in MySQL
yet. You may find doing a JOIN or LEFT JOIN and filtering out NULL
entries to be faster. I don't know where you getting your ids not to
match from, so I can't really give you a good example.
On Feb 4, 2004, at 11:04 PM, Mark
Mark,
You're killing me because I can't visualize the source tables. A query
like this is bread and butter, it shouldn't take to long to execute.
Give me a better idea of the table structure and relationships between
them. I try to help.
Regards,
Adam
On Feb 4, 2004, at 11:04 PM, Mark wrote:
subcategories as Star Wars.
- Mark
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 7:37 AM
To: Mark
Cc: MySQL List
Subject: Re: Faster version of Movie Search
Mark,
You're killing me because I can't visualize the source tables. A query
like