On Feb 17, 2014, at 12:36 PM, Roy Lyseng wrote:
> Try... `ip` IN (SELECT ip FROM temp_ip)
Wow! Only 1 second to return the results now!! That's 15x faster!!!
> Each subquery needs to be a complete SELECT query.
That's good to know. I figured that since temp_ip referenced a
complete SELECT statement from before, that was good enough, but no. There's
always something new to learn!
Thanks again,
Jenni
Superior Shelving Systems::::....
The (Storage|Office|Display|Warehouse) Shelving Specialists
Since 1984
Metro Shelving:
http://www.superiorshelving.com/mfg/metro/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
