Mercurial > hg > orthanc-databases
annotate TODO @ 502:bf4b9c7cf338
todo & notes
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Fri, 03 May 2024 16:22:02 +0200 |
| parents | 827e438439c4 |
| children | a164d8aebe0e |
| rev | line source |
|---|---|
| 196 | 1 |
| 2 ============================== | |
| 3 == Orthanc database plugins == | |
| 4 ============================== | |
| 5 | |
| 6 ----------------------- | |
| 7 Common - Database index | |
| 8 ----------------------- | |
| 9 | |
| 258 | 10 * Performance of joins in LookupResources: Create cached statement for |
| 11 LookupResources, that are grouped to search up to, say, 10 tags, | |
| 12 instead of recompiling for each request | |
| 196 | 13 |
| 502 | 14 * Implement "large queries" for: |
| 15 - updating all metadata of a resource at once | |
| 16 - update all maindicomtags of 4 resource levels at once | |
| 17 | |
| 18 | |
| 196 | 19 --------------------- |
| 20 Common - Storage area | |
| 21 --------------------- | |
| 22 | |
| 23 * Implement the "StoreDicom" option from the default filesystem | |
| 24 storage area to run MySQL/PostgreSQL storage in index-only mode: | |
|
426
d700c8f9fc24
migration to UCLouvain servers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
371
diff
changeset
|
25 https://orthanc.uclouvain.be/book/contributing.html |
| 196 | 26 |
| 259 | 27 * Performance: Add a pool of connections to PostgreSQL/MySQL, as |
| 28 already done in the database index plugins | |
| 29 | |
| 360 | 30 ---------- |
| 31 PostgreSQL | |
| 32 ---------- | |
| 33 | |
| 477 | 34 * Check if we can force the schema that is used. By default, Orthanc |
| 35 is using the 'public' schema but, after a wrong command, we have seen | |
| 36 a DB where there was a 'AttachedFiles' table in the public schema and another one in a | |
| 37 'MyPacs' schema and Orthanc was actually using the 'MyPacs.AttachedFiles' table !!! | |
| 38 Orthanc was then seeing only the most recent attached files !!! | |
| 39 | |
|
473
15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
Alain Mazy <am@osimis.io>
parents:
445
diff
changeset
|
40 * Have a separate "thread" to UpdateStatistics to avoid large computations ? |
|
15e609c439d1
Fixed the MaximumStorageSize & MaximumPatientCount.
Alain Mazy <am@osimis.io>
parents:
445
diff
changeset
|
41 |
| 360 | 42 |
| 365 | 43 * Seems Orthanc might deadlock when there are plenty of conflicting transactions: |
| 44 https://groups.google.com/g/orthanc-users/c/xQelEcKqL9U/m/HsvxwlkvAQAJ | |
| 45 https://groups.google.com/g/orthanc-users/c/1bkClfZ0KBA/m/s4AlwVh3CQAJ | |
| 196 | 46 |
| 47 ----- | |
| 48 MySQL | |
| 49 ----- | |
| 50 | |
|
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
51 * Store revisions for metadata and attachments in MySQL (this is |
|
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
52 already implemented in PostgreSQL) |
|
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
53 |
| 196 | 54 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: |
| 55 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ | |
| 258 | 56 |
| 57 * Add index to speed up wildcard search, as already done in PostgreSQL: | |
| 58 | |
| 59 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + | |
| 60 ALTER TABLE table ADD FULLTEXT index_name(column1); | |
| 61 | |
| 62 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html | |
| 482 | 63 |
| 64 | |
| 65 ---- | |
| 66 ODBC | |
| 67 ---- | |
| 68 | |
| 69 * https://orthanc.uclouvain.be/bugs/show_bug.cgi?id=224 |