Dear Conquest dev & users,
I recently noticed that the data insertion speed (i.e. importing new DICOM images from C-STORE requests) slow down quite dramatically as my database size grows.
With an empty database the insertion speed is 10+ images per second.
With ~ 200GB of data the insertion speed is only 2-3 image per second.
I suspect this is because of database performance.
If I do "Re-initialize database" which seems to clean the metadata database, insertion speed will get back to 10+ images per second.
However as the re-initialization goes and the database entries get filled up again, the insertion speed decreases to 2-3 images per second again.
I'm using Conquest 1.5.0b on Windows Server 2019 + Postgres 9.6 running on the same machine.
I'm using the Native Postgres driver to connect my Postgres to Conquest.
Has anyone encountered similar issues?
Is there any way to fix this? e.g. database optimization, creating indices for certain database rows, etc.
If not, what would be the better database options for large scale production use (10-20 users, ~10TB of data in .v2 format)? MySQL?
Thank you very much for your assistance!
Andy