Mercurial > hg > orthanc-databases
comparison TODO @ 266:cc7af42d4f23
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 |