Mercurial > hg > orthanc-databases

comparison TODO @ 258:9856290c3cfd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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