How to "Reduce your SELECT DISTINCT queries without LIMIT clauses"

Portal Home > Knowledgebase > Articles Database > How to "Reduce your SELECT DISTINCT queries without LIMIT clauses"

Posted by kotlt, 03-28-2009, 04:04 PM
Hello, i want to edit "Reduce your SELECT DISTINCT queries without LIMIT clauses" in my my.cnf . How to do it now ? Thank you
Posted by RBBOT, 03-28-2009, 04:10 PM
I presume you got that advice from the tuning primer. Ignore it- it's assuming one certain cause for a possible performance issue when in reality it could be any one of number of things. All of the ways to fix this certain performance issue, including reducing select distinct queries, are changes to your application code, not to your configuration.