Gowsirrinewar
New Member
I have a database with a fair number of records in it, and I want to find the users that have no user items stored:\[code\]select `name` from `users` where `ID` not in (select distinct `userID` from `userItem`)\[/code\]This query won't even finish executing before it gets cut off by the MySQL server. Is there some huge inefficiency here that I don't know of?There are 200,000 records in \[code\]userItem\[/code\] and 14,000 records in \[code\]users\[/code\].Result from an explain on the query:\[code\]1 PRIMARY users ALL NULL NULL NULL NULL 13369 Using where2 DEPENDENT SUBQUERY userItem index NULL userID 8 NULL 189861 Using where; Using index; Using temporary\[/code\]