Re: query optimization - DB

Hi Micah, I'm learning here. Great! :-) How can I look this up? I'm pretty sure multiple fields are indexed. So should I specify explicitely which indices should be used? What fields do you think should be indexed? I do have control over the database and can create additional indices. Can you help out rewriting the query using EXISTS syntax? Thanks in advance, Yves ----- Original Message ----- From: "Micah Gersten" <micah@onshore.com> To: <php-db@lists.php.net> Sent: Friday, September 26, 2008 11:47 AM Subject: Re: [PHP-DB] query optimization - DB

MySQL queries use 1 index per table, so to speed the query, we need to know what indices you have for the 2 tables. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Yves Sucaet wrote:

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

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