UI takes a lot of time on loading after huge import or export
After a huge import or export the frontend performance decreases and the loading process seems stalled for several seconds until can be completed.
When you import or export documents, these are registered into OKM_DASHBOARD_ACTIVITY table. This table is used for Dashboard view to listing last documents created, modified, etc. A huge number of records in this table can decrease the login performance.
There's a crontab task named "Dashboard Activity Purge" that daily cleans dashboard log older than 3 months. Check that you have enabled.
- Huge import.
- Huge export.
- Periodically ( daily ) import or export. The "Dashboard Activity Purge" crontab task only purges the logs older than tree months.
- Crontab task "Dashboard Activity Purge" is stopped.
Check the number of records in the table OKM_DASHBOARD_ACTIVITY.
select count(*) from OKM_DASHBOARD_ACTIVITY;
Clean values from OKM_DASHBOARD_ACTIVITY based on user ( who imported or exported documents ) or date.
Clean based on user id:
DELETE FROM OKM_DASHBOARD_ACTIVITY WHERE DAC_USER = 'okmAdmin';
Clean based on date:
DELETE FROM OKM_DASHBOARD_ACTIVITY WHERE DAC_DATE < '2016-06-21 00:00:00'