Performance - Add support for data_update_method

twomice / com.joineryhq.jsumfields

Provides additional fields under the Summary Fields framework.

Other

1 stars 10 forks source link

Performance - Add support for data_update_method #20

Open samuelsov opened 3 years ago

samuelsov commented 3 years ago

Currently, the triggers are always enabled. It cause performance problems on big sites for fields like click through which can trigger a lot of quite heavy sql queries.

The extension net.ourpowerbase.sumfields has a setting to avoid just that: Screenshot_2021-08-27_at_10-32-36_Summary_Fields_Administration

The name of the setting is data_update_method and has 2 possible value:

via_triggers
via_cron

If via_cron is selected, the triggers shouldn't be generated.

twomice commented 3 years ago

This is an important point, and a cool solution. I'll follow up with comments in PR #21 .