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 |