Mercurial > hg > orthanc
changeset 6468:af1bc07ae7c2
merge
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Thu, 20 Nov 2025 10:06:01 +0100 |
| parents | 2bf85a1e2b85 (diff) 3cf91621c1da (current diff) |
| children | 4e2f5459c43b |
| files | |
| diffstat | 2 files changed, 6 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/OrthancServer/Sources/Database/InstallDicomIdentifiersIndex3.sql Thu Nov 20 10:00:52 2025 +0100 +++ b/OrthancServer/Sources/Database/InstallDicomIdentifiersIndex3.sql Thu Nov 20 10:06:01 2025 +0100 @@ -20,3 +20,7 @@ CREATE INDEX DicomIdentifiersIndex3 ON DicomIdentifiers(tagGroup, tagElement, value); + +-- remove these 2 old indexes that are now redundant. +DROP INDEX IF EXISTS DicomIdentifiersIndex2; +DROP INDEX IF EXISTS DicomIdentifiersIndexValues; \ No newline at end of file
--- a/OrthancServer/Sources/Database/PrepareDatabase.sql Thu Nov 20 10:00:52 2025 +0100 +++ b/OrthancServer/Sources/Database/PrepareDatabase.sql Thu Nov 20 10:06:01 2025 +0100 @@ -107,8 +107,8 @@ -- 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); -- disabled in 1.12.10 --- CREATE INDEX DicomIdentifiersIndexValues ON DicomIdentifiers(value COLLATE BINARY); - temporarily disabled for testing +-- CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement); -- removed in 1.12.10 (in InstallDicomIdentifiersIndex3.sql) +-- CREATE INDEX DicomIdentifiersIndexValues ON DicomIdentifiers(value COLLATE BINARY); -- removed in 1.12.10 (in InstallDicomIdentifiersIndex3.sql) CREATE INDEX ChangesIndex ON Changes(internalId);