8,849
edits
Changes
no edit summary
The '''Straight Join''' options on the [[Edit Report Page:Category:ReportsAdvanced Settings Tab|Advanced tab]] of the [[Edit Reportpage]] settings page changes the way the system builds the report from the database.
Some reports will open faster if they are built with straight join option enabled. It’s difficult to identify which reports will benefit.
It is best practice to build reports with those attributes both with Straight Join enabled, and then disabled and disable Straight Join to evaluate which option has a faster response when viewing the report.
'''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 MySQL from trying to optimize the query and runs it exactly as provided by the system.
==See Also==
