• Database and folder segregation based on yearwise

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
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.
 #43398  by Rajkumar
 
Hi,

I need one help. I have lot of documents .So i want to create folder by year wise and mapped with separate database per folder.Is this possible to set any property settings in openKM? Otherwise what are the ways are possible .Please reply me.

Thanks,
Rajkumar.R
 #43406  by jllort
 
Database segregation based on folder level is not possible, aplication use a single database connection you can not switch between two databases or between two tables. At the present is not possible.

Why do you need it, what kind of problem are you trying to solve ?
 #43408  by Rajkumar
 
I have planned to used on community edition.In community edition overall file size is limited only.If file size once increased ,i have faced performance issues. Thats y i have planned for database segregation by folder and year wise.Is this possible in community edition otherwise give me the best ways for reduced the performance issues.
 #43418  by jllort
 
Usually, performance issues come with huge import and OKM_DASHBOARD table. From the next version, we have not officially released but what you can check we have introduced profiling stats and hibernate stats. From there you can discover what methods or tables are the cause of low performance.

You can try to build the code from here https://github.com/openkm/document-management-system ( really we only have to release it, but still we have not found time for complete all steps for officially release ).

Take a look here:
https://docs.openkm.com/kcenter/view/ok ... o-633.html
https://docs.openkm.com/kcenter/view/ok ... stats.html
https://docs.openkm.com/kcenter/view/ok ... stats.html

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.