Mercurial > hg > orthanc-databases

comparison TODO @ 529:ec0a100d380e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
todo
author Alain Mazy <am@orthanc.team>
date Tue, 23 Jul 2024 08:58:33 +0200
parents a164d8aebe0e
children 7057d9db8d9a
comparison
equal deleted inserted replaced
528:fa6d3c5ada3d 529:ec0a100d380e
56 * Store revisions for metadata and attachments in MySQL (this is 56 * Store revisions for metadata and attachments in MySQL (this is
57 already implemented in PostgreSQL) 57 already implemented in PostgreSQL)
58 58
59 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast: 59 * MySQL performance => implement GlobalProperty_GetTotalSizeIsFast:
60 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ 60 https://groups.google.com/d/msg/orthanc-users/kSR4a110zDo/D7e4ITR8BwAJ
61 https://discourse.orthanc-server.org/t/when-running-housekeeping-mysqld-exe-searching-and-dicom-transfer-is-slow/4921/9
61 62
62 * Add index to speed up wildcard search, as already done in PostgreSQL: 63 * Add index to speed up wildcard search, as already done in PostgreSQL:
63 64
64 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html + 65 - https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html +
65 ALTER TABLE table ADD FULLTEXT index_name(column1); 66 ALTER TABLE table ADD FULLTEXT index_name(column1);