How can I optimize the loading time of Pages, Modules, Records, and Metrics to the maximum extent possible? I’m experiencing a significant CPU usage issue and need to find a way to optimize the application’s loading/execution time. I’ve already implemented some suggestions mentioned here on the forum, including the following trigger:
create trigger compose_module_after_update
after update
on compose_module
execute procedure after_compose_module_func();
I’m also following these three tips:
- Filtering down record lists to limit the number of records (based on status and user).
- Disabling total count and full page navigation in the record list configurator.
- Using a metric to display the total number of records.
However, I’m still encountering processing bottlenecks.