Mercurial > hg > orthanc-databases
view TODO @ 493:0a8168522165
news
author | Alain Mazy <am@osimis.io> |
---|---|
date | Fri, 22 Mar 2024 15:27:59 +0100 |
parents | 827e438439c4 |
children | bf4b9c7cf338 |
line wrap: on
line source
============================== == Orthanc database plugins == ============================== ----------------------- Common - Database index ----------------------- * Performance of joins in LookupResources: Create cached statement for LookupResources, that are grouped to search up to, say, 10 tags, instead of recompiling for each request --------------------- Common - Storage area --------------------- * Implement the "StoreDicom" option from the default filesystem storage area to run MySQL/PostgreSQL storage in index-only mode: https://orthanc.uclouvain.be/book/contributing.html * Performance: Add a pool of connections to PostgreSQL/MySQL, as already done in the database index plugins ---------- PostgreSQL ---------- * Check if we can force the schema that is used. By default, Orthanc is using the 'public' schema but, after a wrong command, we have seen a DB where there was a 'AttachedFiles' table in the public schema and another one in a 'MyPacs' schema and Orthanc was actually using the 'MyPacs.AttachedFiles' table !!! Orthanc was then seeing only the most recent attached files !!! * Have a separate "thread" to UpdateStatistics to avoid large computations ? * Seems Orthanc might deadlock when there are plenty of conflicting transactions: https://groups.google.com/g/orthanc-users/c/xQelEcKqL9U/m/HsvxwlkvAQAJ https://groups.google.com/g/orthanc-users/c/1bkClfZ0KBA/m/s4AlwVh3CQAJ ----- MySQL ----- * Store revisions for metadata and attachments in MySQL (this is already implemented in PostgreSQL) * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ * Add index to speed up wildcard search, as already done in PostgreSQL: - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + ALTER TABLE table ADD FULLTEXT index_name(column1); - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html ---- ODBC ---- * https://orthanc.uclouvain.be/bugs/show_bug.cgi?id=224