Currency no-join mode

[yurikuzn]

The config parameter currencyNoJoinMode.

Espo applies a join for each currency field to convert a value to the default currency. If an entity has a lot of currency fields it may cause the error 'MySQL can only use 61 tables in a join'. MySQL does not have an option to increase this limitation.

The no-join mode will make Espo to use an SQL expression w/o joining the currency_rate table.

Downside: You will need to clear cache (in Espo) every time you change currency rates.

[yurikuzn]

085e5ef