Question about use in production setting regarding database.

Google Groups archive
1

This is probably a simple question, although there is a part of it that might be more important to know really.

The online documentation talks about database storage here:

How does Orthanc store its database?

I am just wondering what the advantages and disadvantages are.

I would prefer to use MySQL and that looks easy to configure:

https://book.orthanc-server.com/plugins/mysql.html#mysql

I have not looked at the database, but is it possible to query the database rather than using the REST API to query some information about the exams on the server, and how does that compare in speed to using the REST API for a similar query.

Also, what do people usually use for a production environment that is not really that busy though. Maybe 20 MRI’s and a handful of US exams per day ?

BTW I had a previous question that got a few views, but no comments. I actually answered it myself. The Modality Worklist Feature ?

Thanks.

Stephen D. Scotti, M.D.

2

For Small setups like yours, SQLite is the easiest to deploy since you don’t have anything to do. It will keep up the load for years.

We really don’t recommend to access the DB directly to perform queries. The Rest API is there to simplify your life and to abstract the database that is behind. Speed is not a concern.