Mercurial > hg > orthanc-databases
diff PostgreSQL/NEWS @ 522:c49136b34891 large-queries
use a prepared statement for InsertOrUpdateMetadata
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Fri, 05 Jul 2024 09:15:54 +0200 |
parents | 594859656a06 |
children | 9413451fd984 |
line wrap: on
line diff
--- a/PostgreSQL/NEWS Thu Jul 04 07:44:39 2024 +0200 +++ b/PostgreSQL/NEWS Fri Jul 05 09:15:54 2024 +0200 @@ -8,7 +8,11 @@ * Fix updates from plugin version 3.3 to latest version * Added support for ExtendedApiV1: - changes?type=...&to=... - +* Performance optimizations (to be summarized before release): + - using more prepared SQL statements: + - InsertOrUpdateMetadata + - reduced the number of round-trips between Orthanc and the PostgreSQL server: + - e.g: when receiving an instance in an existing series, reduced the number of SQL queries from 13 to 12 (to be continued) Release 6.2 (2024-03-25)