Mercurial > hg > orthanc-databases

diff PostgreSQL/NEWS @ 522:c49136b34891 large-queries tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
use a prepared statement for InsertOrUpdateMetadata
author Alain Mazy <am@orthanc.team>
date Fri, 05 Jul 2024 09:15:54 +0200
parents 594859656a06
children
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)