We have been using OpenKM for 9 months, total number of files reached 3000 and total size of repository reached 30G. The whole system was reinstalled once with repository restored after 6 months of usage because of significant increase in latency of web interface. Despite of a few problems while restoring repository ( security data was completely lost after restoring the repository, but we managed to rebuild them), eventually everything worked.
We ascribed the decrease in efficiency to the limitation of built-in HSQL when the size of database is too large ( at the time of reinstallation, built-in HSQL database reached 500M ). So we switched to mySQL database when we rebuilt the system.
After the new system was set up for 3 months, I found table "OKM_ACTIVITY" enlarges rapidly with no sign of reducing. This table seems to be saving activity log since the system was built, and this table takes up 163M in mySQL database after 3 months of usage. Although there was no apparent sign of efficiency deterioration up till now, eventually this table will cause problem as long as its size monotonously increases.
My question is, is it safe to purge this table manually, or is it possible to add a option for administrators to manage the activity log in administration panel?
Thanks in advance!
We ascribed the decrease in efficiency to the limitation of built-in HSQL when the size of database is too large ( at the time of reinstallation, built-in HSQL database reached 500M ). So we switched to mySQL database when we rebuilt the system.
After the new system was set up for 3 months, I found table "OKM_ACTIVITY" enlarges rapidly with no sign of reducing. This table seems to be saving activity log since the system was built, and this table takes up 163M in mySQL database after 3 months of usage. Although there was no apparent sign of efficiency deterioration up till now, eventually this table will cause problem as long as its size monotonously increases.
My question is, is it safe to purge this table manually, or is it possible to add a option for administrators to manage the activity log in administration panel?
Thanks in advance!