196
|
1
|
|
2 ==============================
|
|
3 == Orthanc database plugins ==
|
|
4 ==============================
|
|
5
|
|
6 -----------------------
|
|
7 Common - Database index
|
|
8 -----------------------
|
|
9
|
257
|
10 * Store revisions for metadata and attachments in PostgreSQL and MySQL
|
|
11
|
258
|
12 * Performance of joins in LookupResources: Create cached statement for
|
|
13 LookupResources, that are grouped to search up to, say, 10 tags,
|
|
14 instead of recompiling for each request
|
|
15
|
196
|
16
|
|
17 ---------------------
|
|
18 Common - Storage area
|
|
19 ---------------------
|
|
20
|
|
21 * Implement the "StoreDicom" option from the default filesystem
|
|
22 storage area to run MySQL/PostgreSQL storage in index-only mode:
|
|
23 https://book.orthanc-server.com/contributing.html
|
|
24
|
|
25
|
|
26 -----
|
|
27 MySQL
|
|
28 -----
|
|
29
|
|
30 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
|
|
31 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
|
258
|
32
|
|
33 * Add index to speed up wildcard search, as already done in PostgreSQL:
|
|
34
|
|
35 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
|
|
36 ALTER TABLE table ADD FULLTEXT index_name(column1);
|
|
37
|
|
38 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
|