UI takes a lot of time on loading after huge import or export

Symptons

After a huge import or export the frontend performance decreases and the loading process seems stalled for several seconds until can be completed.

Cause

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.

Possible causes:

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

Diagnosis

Check the number of records in the table OKM_DASHBOARD_ACTIVITY.

select count(*) from OKM_DASHBOARD_ACTIVITY;

Solution

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'

Properties

Keywords