Re: query optimization - DB
| From: | Yves Sucaet | Date: | Fri, 26 Sep 2008 14:21:52 +0000 |
| Subject: | Re: query optimization - DB | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45467@lists.php.net to get a copy of this message | ||
Oh, sorry I forgot to mention this. It's a MySQL database.
----- Original Message ----- From: "Micah Gersten" <micah@onshore.com>
To: "YVES SUCAET" <yves.sucaet@usa.net>
Cc: <php-db@lists.php.net>
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is, what DB is this for? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com YVES SUCAET wrote:How could I rewrite the following query so it runs faster: select distinct location from blockunit where blockid in ( select bu.blockid from blockunit bu inner join interactionparts ip on (bu.blockid = ip.part) where ip.blockid in (110936,110937,111641,111642,113140,113141,114925,114926,121161,121162,124087, 124088,124562,124563,133358,133359,133409,133410,135304,135305,136096) union select bu.blockid from blockunit bu where bu.blockid in (110936,110937,111641,111642,113140,113141,114925,114926,121161,121162,124087, 124088,124562,124563,133358,133359,133409,133410,135304,135305,136096) ) Thanks in advance, Yves