Also,,,,consider pasting the query here for people to assist you even better...... sometimes its easier to pick the problem when you are seeing it visually.<br><br>Regards<br><br><br><br><br><br><div class="gmail_quote">On Fri, May 22, 2009 at 11:04 AM, Nicholas Loki <span dir="ltr">&lt;<a href="mailto:lokimwenga@yahoo.com">lokimwenga@yahoo.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">IMO I think the performance of the subquery found in the <span style="font-family: -webkit-monospace; line-height: 15px; white-space: pre;">WHERE EXISTS<span style="font-family: arial; line-height: normal; white-space: normal;"> and <span style="font-family: -webkit-monospace; line-height: 15px; white-space: pre;">WHERE NOT EXISTS </span>clauses could be affecting the performance of your view. See if you can tune this query either by adding indexes to the key fields of your query or using conditions that allow you to fetch smaller datasets if possible. Also consider doing the same for your outer query.</span></span><div>
<div> </div><span style="font-style: italic;">&quot;Excellent people exceed
 expectations&quot;.</span><div><br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div class="hm"><br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">
<div class="hm"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Oj G &lt;<a href="mailto:ojiwaj@yahoo.com" target="_blank">ojiwaj@yahoo.com</a>&gt;<br><b><span style="font-weight: bold;">To:</span></b> Skunkworks forum &lt;<a href="mailto:skunkworks@lists.my.co.ke" target="_blank">skunkworks@lists.my.co.ke</a>&gt;<br>
<b><span style="font-weight: bold;">Sent:</span></b> Friday, May 22, 2009 9:15:22 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [Skunkworks] myDBA gurus<br></font></div><div class="im"><br>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">
mySQL 5 is performing poorly when it comes to WHERE EXISTS AND NOT EXIST in views...<br><br>any myDBA with ideas how to optimize this...?<br><br><br>========================================<br><br>The optimist sees the doughnut; the pessimist the hole.<br>
</td></tr></tbody></table><br>

      </div></div></div><div></div></div></div><br>

      </div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br>
Other lists<br>
-------------<br>
Skunkworks announce: <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce</a><br>
Science - <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/science" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/science</a><br>
kazi - <a href="http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general</a><br>
<br></blockquote></div><br>