Open Source Document Management System | OpenKM

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 ?

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 )

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%.

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