• General Performance Issues

  • OpenKM has many interesting features, but requires some configuration process to show its full potential.
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.
 #53798  by scrumi
 
I have a moderately sized amount of documents 150,000 or so. The server is a pretty robust 16 core Xeon with 128GB of DDR3 ram, generation or so old but still relatively beefy for the moderate amount of records we are dealing with.

The things that I'm seeing taking longer that I'm expecting is mostly changing permissions recursively. On some folders it will sit there for tens of minutes and some of my larger folders it will actually time out and fail. This seems a bit odd to me as I would assume that permissions are just database flags yet my separate database server barely has any load on it at all while the openKM server has the java application just thrashing the processor. Is there a documented schema that I can see so I can just write the queries directly on the DB server and just skip openKM all together? I get the impression that the recursing is being done in the application rather than in the database which doesn't seem like an efficient way to update records.

Other items which are mildly delayed are things like "Updating list" can take up to 5 seconds to display the first page of 50 items when there are only 2000 items in the folder. (pagination default is set to 50 items)
 #53813  by jllort
 
Thinks do not work in the way you think. The problem is not only applying changes in the database application does a lot of things while changing security. Consider that in a tree may do not have grants to access everything because do not have privileges for it, or can access but do not have grants to change security etc... that means it is not a simple blind update, must be executed some controls before doing the action for each node.

Finally, each database update raises an event to the search engine that is also updated. Changes from the database side may create a big issue because the database and search engine will not sync.

In professional edition huge changes are done in the background, currently this feature is not implemented in the CE.

About database structure maybe interested on https://docs.openkm.com/kcenter/view/ok ... ption.html ( security tables are named OKM_NODE_USER_PERMISSIONS and OKM_NODE_ROLE_PERMISSIONS) -> if you decide to update from database -> should rebuild all the lucene indexes > have a tool for it in the administration

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.