Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » The Slowness of "WHERE something IN (SELECT....)"
The Slowness of "WHERE something IN (SELECT....)" [message #2959] Tue, 15 April 2008 10:55 Go to previous message
tobias74 is currently offline tobias74
Messages: 4
Registered: April 2008
Junior Member
Hello!

When discussing performance issues on inner-join-queries, people tend to advise using a subquery like "SELECT id FROM table WHERE value IN (SELECT something FROM othertable WHERE original_condition)".

As this strategy did not work for me at all, I kept looking for some solution and came across an article which can be found at http://www.artfulsoftware.com/infotree/queries.php#568

Now my question would be, whether "IN (*subquery*)" is ever fit to optimize a query, and if so, how?

Tobias
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:dump/reload in master-master
Next Topic:Is there a way to control query expiration time in cache?
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 02:31:03 EDT 2009

Total time taken to generate the page: 0.04657 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.