Re: [PHP-DB] query optimization - DB

[Yves Sucaet]

Oh, sorry I forgot to mention this. It's a MySQL database.
----- Original Message ----- 
From: "Micah Gersten" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>
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








--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php