The database has become 2TB, stopped running. Number of research somewhere 8000. I tried to install a new version of the program, the error repeats.When creating a new database in another folder, there is no error. Are there any restrictions on the size of the database (SQLite), the index file?
CONFIG.txt (17.6 KB)
LOG.txt (4.02 KB)
Well, the limits sem to be of more of general nature (IE. not directly Orthanc related). Loading a 2TB sqlite database is bound to take sometime unless you have incredibly fast storage. At those levels I would recommend you look into a professionally maintained relational database, such as postgresql, mysql or mariadb.
Yes.
I believe there’s a thread in which Sebastien says that for a given number of images you’re better off with a RDBMS.
In our own case we chose PostgreSQL for indexing and filesystem for storage.
What you’ll have to cope with is importing your old SQLite-based Orthanc images into your new more robust one. I believe you can script that with the Rest API. In case you never used the /changes URL then it’s even easier since it has all the info you need, just be careful with the paging options.
Cheers
Thanks for your help!
Hello,
This is documented in the Orthanc Book:
http://book.orthanc-server.com/faq/troubleshooting.html#performance-issues => “As a rule of thumb, the performance of the default SQLite engine built in Orthanc should run fine up to about 50,000 DICOM instances.”
http://book.orthanc-server.com/users/replication.html#direct-access-to-the-filesystem => “The most direct way to replicate an instance of Orthanc consists in using the ImportDicomFiles script of the Orthanc distribution.”
Sébastien-