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)
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)