Changes

The '''Straight Join''' options on the [[:Category:Reports|Report]] 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 to identify which reports (otherwise we’d do it automatically)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.

 '''Important:''' if when the '''Straight Join''' option is enabled or disabled, the report must be rebuilt before the change will take effect.

* 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.