OpenKM Community Performance Question

[AthenaAutomation]

Hello,

I had a question in regards to the limits of OpenKM Community 6.2.2.

We are running it on:
-Windows Server 2008 R2 Standard 64bit OS with a Quad-Core Xeon CPU and 10GB memory
-PostgreSQL (32bit) on same server

Our current database repository is under 5GB and planned number of users is 30-75.

I understand that there are some PostgreSQL optimizations to be made, but in terms on OpenKM itself, is the Community edition suitable for a deployment this size, or is the Professional edition required? If so, what more does the Pro edition give us?

Thank you,

Alex

[jllort]

The professional edition has some memory and cache optimizations which are not present in community edition.

[AthenaAutomation]

Thanks for the response

[jllort]

With professional version we got customer with some milions of docs in a single installation. That can not be hold with openkm without some optimization ( not only in database ). In a middle-high size installation sometimes is needed make some specific optimization based on customer needs ( is quite dificult to explain but each customer is a world ).

[AthenaAutomation]

I see, so the Pro edition is definitely needed for larger scale deployments. We just started testing out OpenKM Community edition with a good 70 users and so far our Repository is sitting at ~1.5GB with ~7,000 files and ~22,000 folders.

1-What's the best way to get the total document/folder count for the full repository? Not sure if right-clicking on the folder in Windows and choosing properties is 100% accurate?
2-Is it possible to upgrade from Community to Professional editions down the road?

Thanks

[jllort]

There's no problem to migrate between version. And about count you got Administration -> stats ( need some time to calculate repository size after openkm started ) or simply go to Administration -> databas query and then select count to OKM_NODE_DOCUMENT or OKM_NODE_FOLDER tables;

[AthenaAutomation]

Our Stats page displays "No data to display" for Documents, Documents by Size, and Folder by context graphs.

Also, not sure if I'm doing this right, but sending select count to OKM_NODE_DOCUMENT or OKM_NODE_FOLDER tables; outputs:
ERROR: syntax error at or near "to" Position: 14

But you did point me to the right direction, as I logged into pgAdmin (postgres db administrator) and browsed to the okm_node_document table, then performed a count and got 6284 back, which sounds correct.

Also worked for okm_node_folder, with 30,776.

Thanks

[jllort]

Code: Select all

select count(*) from OKM_NODE_DOCUMENT

As I indicated stats view is active after openkm calculates something ( needs sometime after startup ).