Mercurial > hg > orthanc-databases

annotate TODO @ 266:cc7af42d4f23

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Store revisions for metadata and attachments in PostgreSQL
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Apr 2021 17:41:44 +0200
parents 93a6efd7d8e5
children 1d57fac91104
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
2 ==============================
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
3 == Orthanc database plugins ==
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
4 ==============================
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
6 -----------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
7 Common - Database index
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
8 -----------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
9
258
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
10 * Performance of joins in LookupResources: Create cached statement for
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
11 LookupResources, that are grouped to search up to, say, 10 tags,
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
12 instead of recompiling for each request
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
13
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
14
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
15 ---------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
16 Common - Storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
17 ---------------------
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
18
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
19 * Implement the "StoreDicom" option from the default filesystem
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
20 storage area to run MySQL/PostgreSQL storage in index-only mode:
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
21 https://book.orthanc-server.com/contributing.html
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
22
259
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
23 * Performance: Add a pool of connections to PostgreSQL/MySQL, as
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
24 already done in the database index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 258
diff changeset
25
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
26
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
27 -----
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
28 MySQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
29 -----
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
30
266
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 259
diff changeset
31 * 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
32 already implemented in PostgreSQL)
cc7af42d4f23 Store revisions for metadata and attachments in PostgreSQL
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 259
diff changeset
33
196
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
34 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
diff changeset
35 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
258
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
36
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
37 * Add index to speed up wildcard search, as already done in PostgreSQL:
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
38
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
39 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
40 ALTER TABLE table ADD FULLTEXT index_name(column1);
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
41
Sebastien Jodogne <s.jodogne@gmail.com>
parents: 257
diff changeset
42 - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html