Mercurial > hg > orthanc-databases
annotate TODO @ 454:f4244c7e2725 improve-delete
merge pg-transactions -> improve-delete
author | Alain Mazy <am@osimis.io> |
---|---|
date | Mon, 22 Jan 2024 10:00:28 +0100 |
parents | 95c413106a66 cec6a0cd399f |
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 | |
371 | 13 * Do not log "DatabaseCannotSerialize" errors in the plugin but only |
14 in Orthanc after all retries have been made. | |
424
95c413106a66
Introduced a procedure to delete resources (to be tested)
Alain Mazy <am@osimis.io>
parents:
371
diff
changeset
|
15 * Try to avoid the use of temporary tables: |
95c413106a66
Introduced a procedure to delete resources (to be tested)
Alain Mazy <am@osimis.io>
parents:
371
diff
changeset
|
16 https://discourse.orthanc-server.org/t/image-insert-are-too-slow-databse-performance-too-poor/3820 |
95c413106a66
Introduced a procedure to delete resources (to be tested)
Alain Mazy <am@osimis.io>
parents:
371
diff
changeset
|
17 |
196 | 18 |
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 | |
34 * reported issue to validate: uploading lots of files through HTTP with: | |
35 - 1 client and IndexConnectionsCount==1 took 100s | |
36 - 2 client and IndexConnectionsCount==2 took 600s (lots of transaction replayed) | |
37 | |
365 | 38 * Seems Orthanc might deadlock when there are plenty of conflicting transactions: |
39 https://groups.google.com/g/orthanc-users/c/xQelEcKqL9U/m/HsvxwlkvAQAJ | |
40 https://groups.google.com/g/orthanc-users/c/1bkClfZ0KBA/m/s4AlwVh3CQAJ | |
196 | 41 |
42 ----- | |
43 MySQL | |
44 ----- | |
45 | |
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
46 * 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
|
47 already implemented in PostgreSQL) |
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
48 |
196 | 49 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: |
50 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ | |
258 | 51 |
52 * Add index to speed up wildcard search, as already done in PostgreSQL: | |
53 | |
54 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + | |
55 ALTER TABLE table ADD FULLTEXT index_name(column1); | |
56 | |
57 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html |