Database and folder segregation based on yearwise

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.
Post Reply
Rajkumar
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: Mon Mar 13, 2017 4:15 am

Database and folder segregation based on yearwise

Post by Rajkumar » Mon Mar 13, 2017 7:31 am

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

jllort
Moderator
Moderator
Posts: 9647
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Database and folder segregation based on yearwise

Post by jllort » Tue Mar 14, 2017 7:45 pm

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 ?

Rajkumar
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: Mon Mar 13, 2017 4:15 am

Re: Database and folder segregation based on yearwise

Post by Rajkumar » Wed Mar 15, 2017 5:16 am

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.

jllort
Moderator
Moderator
Posts: 9647
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Database and folder segregation based on yearwise

Post by jllort » Thu Mar 16, 2017 11:27 am

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

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests