Mercurial > hg > orthanc
changeset 6467:2bf85a1e2b85
SQLite: remove 2 unused indexes when upgrading
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Thu, 20 Nov 2025 10:05:19 +0100 |
| parents | b0251a5ab8ab |
| children | af1bc07ae7c2 |
| files | OrthancServer/Sources/Database/InstallDicomIdentifiersIndex3.sql OrthancServer/Sources/Database/PrepareDatabase.sql |
| diffstat | 2 files changed, 6 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/OrthancServer/Sources/Database/InstallDicomIdentifiersIndex3.sql Thu Nov 20 08:48:58 2025 +0100 +++ b/OrthancServer/Sources/Database/InstallDicomIdentifiersIndex3.sql Thu Nov 20 10:05:19 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 08:48:58 2025 +0100 +++ b/OrthancServer/Sources/Database/PrepareDatabase.sql Thu Nov 20 10:05:19 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);