22 May
2009
22 May
'09
10:23 a.m.
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