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
|
259
|
25 * Performance: Add a pool of connections to PostgreSQL/MySQL, as
|
|
26 already done in the database index plugins
|
|
27
|
196
|
28
|
|
29 -----
|
|
30 MySQL
|
|
31 -----
|
|
32
|
|
33 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
|
|
34 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
|
258
|
35
|
|
36 * Add index to speed up wildcard search, as already done in PostgreSQL:
|
|
37
|
|
38 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
|
|
39 ALTER TABLE table ADD FULLTEXT index_name(column1);
|
|
40
|
|
41 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
|