# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1730893413 -3600
# Node ID 14bd2e248417e0d48eace0931954f72c131ac667
# Parent  8d75255b4272e96224d5a1cb38238240523294cc
PG: new default values for configurations TransactionMode & IndexConnectionsCount

diff -r 8d75255b4272 -r 14bd2e248417 Framework/PostgreSQL/PostgreSQLParameters.cpp
--- a/Framework/PostgreSQL/PostgreSQLParameters.cpp	Wed Nov 06 10:46:49 2024 +0100
+++ b/Framework/PostgreSQL/PostgreSQLParameters.cpp	Wed Nov 06 12:43:33 2024 +0100
@@ -102,7 +102,7 @@
     maxConnectionRetries_ = configuration.GetUnsignedIntegerValue("MaximumConnectionRetries", 10);
     connectionRetryInterval_ = configuration.GetUnsignedIntegerValue("ConnectionRetryInterval", 5);
 
-    std::string transactionMode = configuration.GetStringValue("TransactionMode", "Serializable");
+    std::string transactionMode = configuration.GetStringValue("TransactionMode", "ReadCommitted");
     if (transactionMode == "ReadCommitted")
     {
       LOG(WARNING) << "PostgreSQL: using READ COMMITTED transaction mode";
diff -r 8d75255b4272 -r 14bd2e248417 PostgreSQL/NEWS
--- a/PostgreSQL/NEWS	Wed Nov 06 10:46:49 2024 +0100
+++ b/PostgreSQL/NEWS	Wed Nov 06 12:43:33 2024 +0100
@@ -16,6 +16,9 @@
   - 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 9
 * Fixed a memory leak when executing non cached SQL statements (rarely used)
+* New default values for configurations:
+  - "IndexConnectionsCount": 50
+  - "TransactionMode": "ReadCommitted"
 
 
 Release 6.2 (2024-03-25)
diff -r 8d75255b4272 -r 14bd2e248417 PostgreSQL/Plugins/IndexPlugin.cpp
--- a/PostgreSQL/Plugins/IndexPlugin.cpp	Wed Nov 06 10:46:49 2024 +0100
+++ b/PostgreSQL/Plugins/IndexPlugin.cpp	Wed Nov 06 12:43:33 2024 +0100
@@ -74,7 +74,7 @@
     
     try
     {
-      const size_t countConnections = postgresql.GetUnsignedIntegerValue("IndexConnectionsCount", 1);
+      const size_t countConnections = postgresql.GetUnsignedIntegerValue("IndexConnectionsCount", 50);
 
       OrthancDatabases::PostgreSQLParameters parameters(postgresql);
       OrthancDatabases::IndexBackend::Register(