Mercurial > hg > orthanc-databases

comparison 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
comparison
equal deleted inserted replaced
265:cd73e34d5411 266:cc7af42d4f23
4 ============================== 4 ==============================
5 5
6 ----------------------- 6 -----------------------
7 Common - Database index 7 Common - Database index
8 ----------------------- 8 -----------------------
9
10 * Store revisions for metadata and attachments in PostgreSQL and MySQL
11 9
12 * Performance of joins in LookupResources: Create cached statement for 10 * Performance of joins in LookupResources: Create cached statement for
13 LookupResources, that are grouped to search up to, say, 10 tags, 11 LookupResources, that are grouped to search up to, say, 10 tags,
14 instead of recompiling for each request 12 instead of recompiling for each request
15 13
28 26
29 ----- 27 -----
30 MySQL 28 MySQL
31 ----- 29 -----
32 30
31 * Store revisions for metadata and attachments in MySQL (this is
32 already implemented in PostgreSQL)
33
33 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: 34 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
34 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ 35 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
35 36
36 * Add index to speed up wildcard search, as already done in PostgreSQL: 37 * Add index to speed up wildcard search, as already done in PostgreSQL:
37 38