8,849
edits
Changes
no edit summary
'''Technical Details:'''
* MYSQL5 MySQL5 has a process to optimize queries that in some cases actually reduces the performance. This is a known issue with MYSQL5MySQL5
* Enabling the straight join prevents MYSQL from trying to optimize the query and runs it exactly as provided by the system.