OpenKM installation using MS SQL Server as database engine

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
dharm826
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: Mon Dec 09, 2019 5:38 am

OpenKM installation using MS SQL Server as database engine

Post by dharm826 »

Hi
I want to use SQL server as db engine. Can you list out its pros and cons. Is there any latency issue while using it ?

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

Re: OpenKM installation using MS SQL Server as database engine

Post by jllort »

SQL Server is a good database like MySQL, MariaDB, PostgreSQL or Oracle. The point really is if you have a control of the database or not. Usually for less 200-500K files with medium hardware it is enought to get OpenKM running with good performance without database tunning. But all it depends on your hardware, how users working with the application etc... there's not a magic receipt for suggesting a hardware configuration. For example with linux, always you will get better performance.

If you explain your case might be we can guide you. We need an explanation in terms of:
1- initial number of files
2- how many files will be created per year
3- OS
4- virtualized or dedicated server?
5- do you have some huge daily import process? how many users do you expect and what type do you have ( % of readers and % of writers )

dharm826
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: Mon Dec 09, 2019 5:38 am

Re: OpenKM installation using MS SQL Server as database engine

Post by dharm826 »

Thanks for sharing this information. The most highlighted and crucial factors here are hardware configuration and application usage.

The details have been shared below.

1- initial number of files - may vary 100k-200k
2- how many files will be created per year - approximately 40k-50k
3- OS (Windows)
4- virtualized or dedicated server (virtualised)?
5- do you have some huge daily import process? how many users do you expect and what type do you have ( % of readers and % of writers ) -
The huge import process will less likely on daily basis. Readers approx 70% and writers 20-30%.

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

Re: OpenKM installation using MS SQL Server as database engine

Post by jllort »

Should not have problems, usually until 1 million of docs you do not need to start thinking to optimize the database. Thinking in 500K files I suggest the following configuration
4 core ( might be 8 )
12-16GB of ram
I suggest a good disk for the OS and database SSD ( 250GB ) to store data the speed of a SATA is enought
I suggest Linux if you want the best performance

Post Reply