Page 1 of 1

Database and folder segregation based on yearwise

PostPosted:Mon Mar 13, 2017 7:31 am
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

Re: Database and folder segregation based on yearwise

PostPosted:Tue Mar 14, 2017 7:45 pm
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 ?

Re: Database and folder segregation based on yearwise

PostPosted:Wed Mar 15, 2017 5:16 am
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.

Re: Database and folder segregation based on yearwise

PostPosted:Thu Mar 16, 2017 11:27 am
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