Mercurial > hg > orthanc-databases
comparison TODO @ 258:9856290c3cfd
todo
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 16 Apr 2021 17:45:11 +0200 |
parents | 316f7b981e94 |
children | 93a6efd7d8e5 |
comparison
equal
deleted
inserted
replaced
257:316f7b981e94 | 258:9856290c3cfd |
---|---|
6 ----------------------- | 6 ----------------------- |
7 Common - Database index | 7 Common - Database index |
8 ----------------------- | 8 ----------------------- |
9 | 9 |
10 * Store revisions for metadata and attachments in PostgreSQL and MySQL | 10 * Store revisions for metadata and attachments in PostgreSQL and MySQL |
11 | |
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 | |
11 | 15 |
12 | 16 |
13 --------------------- | 17 --------------------- |
14 Common - Storage area | 18 Common - Storage area |
15 --------------------- | 19 --------------------- |
23 MySQL | 27 MySQL |
24 ----- | 28 ----- |
25 | 29 |
26 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: | 30 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: |
27 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ | 31 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ |
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 |