Hello all. I’ve just integrated the Orthanc product into our veterinary system here. It’s a wonderful product, and I just wanted to know what is the criteria behind the choice to use Mysql vs Postgres vs Sqlite (bundled) ? What did the designers have in mind regarding the sorts of volumes that would drive the decision - so i can perhaps put the rationale forward to my decision here in our small clinic.
Regards
Sean
Hello,
I think the following FAQ in the Orthanc Book should answer most of your questions:
https://book.orthanc-server.com/faq/scalability.html
Regarding the question “PostgreSQL vs. MySQL”, we recommend using PostgreSQL as we have more experience with it.
The official release 2.0 of the MySQL plugins is currently missing some optimizations that the PostgreSQL plugins already feature. Check out the “pending changes” section:
https://hg.orthanc-server.com/orthanc-databases/file/default/MySQL/NEWS
We feel that MySQL should be reserved to IT staffs who are more comfortable with this technology, for instance if they already manage other MySQL databases.
HTH,
Sébastien-
Hello,
I think the following FAQ in the Orthanc Book should answer most of your questions:
https://book.orthanc-server.com/faq/scalability.html
Regarding the question “PostgreSQL vs. MySQL”, we recommend using PostgreSQL as we have more experience with it.
The official release 2.0 of the MySQL plugins is currently missing some optimizations that the PostgreSQL plugins already feature. Check out the “pending changes” section:
https://hg.orthanc-server.com/orthanc-databases/file/default/MySQL/NEWS
We feel that MySQL should be reserved to IT staffs who are more comfortable with this technology, for instance if they already manage other MySQL databases.
HTH,
Sébastien-
Thank you. I missed that article. It answers my questions.