Mercurial > hg > orthanc-databases
annotate TODO @ 360:1d57fac91104 OrthancOdbc-1.1
todo
author | Alain Mazy <am@osimis.io> |
---|---|
date | Thu, 28 Apr 2022 14:24:55 +0200 |
parents | cc7af42d4f23 |
children | c34510606a18 |
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 | |
13 | |
196 | 14 |
15 --------------------- | |
16 Common - Storage area | |
17 --------------------- | |
18 | |
19 * Implement the "StoreDicom" option from the default filesystem | |
20 storage area to run MySQL/PostgreSQL storage in index-only mode: | |
21 https://book.orthanc-server.com/contributing.html | |
22 | |
259 | 23 * Performance: Add a pool of connections to PostgreSQL/MySQL, as |
24 already done in the database index plugins | |
25 | |
360 | 26 ---------- |
27 PostgreSQL | |
28 ---------- | |
29 | |
30 * reported issue to validate: uploading lots of files through HTTP with: | |
31 - 1 client and IndexConnectionsCount==1 took 100s | |
32 - 2 client and IndexConnectionsCount==2 took 600s (lots of transaction replayed) | |
33 | |
196 | 34 |
35 ----- | |
36 MySQL | |
37 ----- | |
38 | |
266
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
39 * 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
|
40 already implemented in PostgreSQL) |
cc7af42d4f23
Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
259
diff
changeset
|
41 |
196 | 42 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: |
43 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ | |
258 | 44 |
45 * Add index to speed up wildcard search, as already done in PostgreSQL: | |
46 | |
47 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + | |
48 ALTER TABLE table ADD FULLTEXT index_name(column1); | |
49 | |
50 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html |