On Fri, May 22, 2009 at 9:15 AM, Oj G <ojiwaj@yahoo.com> wrote:
mySQL 5 is performing poorly when it comes to WHERE EXISTS AND NOT EXIST in views...

Hmm, I am not a DBA, but I know that most of the time you can get better performance by INDEXING your tables.



any myDBA with ideas how to optimize this...?

http://wiki.mysqltuner.com/MySQLTuner

That will do you a lot of good, if you follow its recommendations.


--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
"Clothes make the man.  Naked people have little or no influence on society."
              -- Mark Twain