Mercurial > hg > orthanc-databases
annotate TODO @ 446:9e039e65d68e pg-transactions
notes
| author | Alain Mazy <am@osimis.io> |
|---|---|
| date | Mon, 15 Jan 2024 15:21:43 +0100 |
| parents | cec6a0cd399f |
| children | f4244c7e2725 15e609c439d1 |
| 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 |
| 14 --------------------- | |
| 15 Common - Storage area | |
| 16 --------------------- | |
| 17 | |
| 18 * Implement the "StoreDicom" option from the default filesystem | |
| 19 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
|
20 https://orthanc.uclouvain.be/book/contributing.html |
| 196 | 21 |
| 259 | 22 * Performance: Add a pool of connections to PostgreSQL/MySQL, as |
| 23 already done in the database index plugins | |
| 24 | |
| 360 | 25 ---------- |
| 26 PostgreSQL | |
| 27 ---------- | |
| 28 | |
| 29 * reported issue to validate: uploading lots of files through HTTP with: | |
| 30 - 1 client and IndexConnectionsCount==1 took 100s | |
| 31 - 2 client and IndexConnectionsCount==2 took 600s (lots of transaction replayed) | |
| 32 | |
| 365 | 33 * Seems Orthanc might deadlock when there are plenty of conflicting transactions: |
| 34 https://groups.google.com/g/orthanc-users/c/xQelEcKqL9U/m/HsvxwlkvAQAJ | |
| 35 https://groups.google.com/g/orthanc-users/c/1bkClfZ0KBA/m/s4AlwVh3CQAJ | |
| 196 | 36 |
| 37 ----- | |
| 38 MySQL | |
| 39 ----- | |
| 40 | |
|
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
41 * 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
|
42 already implemented in PostgreSQL) |
|
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
43 |
| 196 | 44 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: |
| 45 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ | |
| 258 | 46 |
| 47 * Add index to speed up wildcard search, as already done in PostgreSQL: | |
| 48 | |
| 49 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + | |
| 50 ALTER TABLE table ADD FULLTEXT index_name(column1); | |
| 51 | |
| 52 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html |