My openkm is too slow

OpenKM has many interesting features, but requires some configuration process to show its full potential.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
Post Reply
mamad
Expert Boarder
Expert Boarder
Posts: 112
Joined: Mon Jun 25, 2018 5:13 am

My openkm is too slow

Post by mamad » Mon Jun 10, 2019 5:48 am

Hey there,
Recently i have been imported a lots of files(about 10000) into openkm and now it is too slow on loading folders,for example when i click on a folder it takes about 10-15 seconds loading the folder and show its documents.during this time the following gift shows on screen :
Untitled.png
Untitled.png (5.02 KiB) Viewed 1636 times
This is a snapshot of the statistics tab :
Capture (1).PNG
(Im using openkm 6.3.7 community edition )

mamad
Expert Boarder
Expert Boarder
Posts: 112
Joined: Mon Jun 25, 2018 5:13 am

Re: My openkm is too slow

Post by mamad » Mon Jun 10, 2019 6:59 am

please also note to this point that i used some metadata values for each document and import the data to openkm by execute thousand lines of queries.
I am suspected of metadatas to slow down the system :roll:

jllort
Moderator
Moderator
Posts: 10868
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: My openkm is too slow

Post by jllort » Thu Jun 13, 2019 5:53 pm

Try deleting all the records from tables:
OKM_DASHBOARD
OKM_DASHBOARD_ACTIVITY

Post Reply