Mercurial > hg > orthanc
changeset 6356:502f8cbd533e queues-timeout
Test DicomIdentifiersIndexGroupElementValue
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Tue, 28 Oct 2025 10:29:11 +0100 |
| parents | 7de5b2b09072 |
| children | 1facef20a778 |
| files | NEWS OrthancServer/Sources/Database/PrepareDatabase.sql |
| diffstat | 2 files changed, 5 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/NEWS Fri Oct 17 14:44:26 2025 +0200 +++ b/NEWS Tue Oct 28 10:29:11 2025 +0100 @@ -1,6 +1,8 @@ Pending changes in the mainline =============================== +TODO: finalize DicomIdentifiersIndex (upgrade from existing DB) + General -------
--- a/OrthancServer/Sources/Database/PrepareDatabase.sql Fri Oct 17 14:44:26 2025 +0200 +++ b/OrthancServer/Sources/Database/PrepareDatabase.sql Tue Oct 28 10:29:11 2025 +0100 @@ -107,9 +107,11 @@ -- The 3 following indexes were added in Orthanc 0.8.5 (database v5) CREATE INDEX DicomIdentifiersIndex1 ON DicomIdentifiers(id); -CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement); +-- CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement); -- disabled in 1.12.10 CREATE INDEX DicomIdentifiersIndexValues ON DicomIdentifiers(value COLLATE BINARY); +CREATE INDEX DicomIdentifiersIndexGroupElementValue ON DicomIdentifiers(tagGroup, tagElement, value); -- added in 1.12.10 + CREATE INDEX ChangesIndex ON Changes(internalId);