Mercurial > hg > orthanc-databases
changeset 258:9856290c3cfd
todo
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Fri, 16 Apr 2021 17:45:11 +0200 |
| parents | 316f7b981e94 |
| children | 93a6efd7d8e5 |
| files | TODO |
| diffstat | 1 files changed, 11 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/TODO Fri Apr 16 17:20:37 2021 +0200 +++ b/TODO Fri Apr 16 17:45:11 2021 +0200 @@ -9,6 +9,10 @@ * Store revisions for metadata and attachments in PostgreSQL and MySQL +* Performance of joins in LookupResources: Create cached statement for + LookupResources, that are grouped to search up to, say, 10 tags, + instead of recompiling for each request + --------------------- Common - Storage area @@ -25,3 +29,10 @@ * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ + +* Add index to speed up wildcard search, as already done in PostgreSQL: + + - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + + ALTER TABLE table ADD FULLTEXT index_name(column1); + + - https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html