• OpenKM installation using MS SQL Server as database engine

  • 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.
 #50110  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 )
 #50134  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%.
 #50147  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

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.