# HG changeset patch
# User Sebastien Jodogne <s.jodogne@gmail.com>
# Date 1546957706 -3600
# Node ID 705fa44471544cecee482892838d7010f9beacad
# Parent  2bc4598c849dddd5348819f51dbec8b2b4f66460
cont

diff -r 2bc4598c849d -r 705fa4447154 PerfsDb/README.md
--- a/PerfsDb/README.md	Mon Jan 07 10:26:41 2019 +0100
+++ b/PerfsDb/README.md	Tue Jan 08 15:28:26 2019 +0100
@@ -46,9 +46,10 @@
 pip install -r requirements.txt
 ```
 
-To enter the virtual-env the next times:
+To enter the virtual-env the next times (on benchmark VM):
 
 ```bash
+cd /data-hdd-3g/orthanc-tests/PerfsDb
 source .env/bin/activate
 ```
 
@@ -60,7 +61,7 @@
 python Run.py --orthanc-path=/home/amazy/builds/orthanc-build-release/ --plugins-path=/home/amazy/builds/mysql-release/ --init --mysql-tiny
 
 on benchmark VM:
-python Run.py --orthanc-path=/data-hdd-3g/orthanc-binaries/ --plugins-path=/data-hdd-3g/orthanc-binaries/ --init --pg9bis-tiny
+python Run.py --orthanc-path=/data-hdd-3g/orthanc-binaries/ --plugins-path=/data-hdd-3g/orthanc-binaries/ --init --pg9bis-small
 ```
 
 Clearing a DB
@@ -71,7 +72,7 @@
 python Run.py --orthanc-path=/home/amazy/builds/orthanc-build-release/ --plugins-path=/home/amazy/builds/mysql-release/ --clear --mysql-tiny
 
 on benchmark VM:
-python Run.py --orthanc-path=/data-hdd-3g/orthanc-binaries/ --plugins-path=/data-hdd-3g/orthanc-binaries/ --clear --pg9bis-tiny
+python Run.py --orthanc-path=/data-hdd-3g/orthanc-binaries/ --plugins-path=/data-hdd-3g/orthanc-binaries/ --clear --pg9bis-small
 ```
 
 Runing tests on multiple DBs
diff -r 2bc4598c849d -r 705fa4447154 PerfsDb/Results/history.txt
--- a/PerfsDb/Results/history.txt	Mon Jan 07 10:26:41 2019 +0100
+++ b/PerfsDb/Results/history.txt	Tue Jan 08 15:28:26 2019 +0100
@@ -1,4 +1,4 @@
-on 31-08-2018 with Orthanc 1.4.1.  Executed on Azure benchmark VM:
+on 2018-08-31 with Orthanc 1.4.1.  Executed on Azure benchmark VM:
 
 ++++++++++++++ results summary +++++++++++++++
                                         |  mssql-large  | sqlite-large  |   pg9-large   | mysql-medium  |  mysql-small  |  mysql-tiny   |  pg9-medium   |   pg9-small   |   pg9-tiny    | sqlite-medium | sqlite-small  |  sqlite-tiny  |
@@ -16,3 +16,24 @@
 UploadLargeFile10MB                     |      58.58 ms |      92.87 ms |      55.91 ms |      76.39 ms |      58.80 ms |      59.44 ms |      68.63 ms |      53.09 ms |      54.68 ms |      60.89 ms |      52.75 ms |      50.79 ms |
 UploadNextPatientFile                   |      12.67 ms |      44.21 ms |       7.59 ms |      23.68 ms |      11.70 ms |      11.41 ms |      17.64 ms |       6.23 ms |       6.31 ms |      13.98 ms |       4.91 ms |       3.18 ms |
 
+
+
+
+
+on 2019-01-08 with Orthanc "db-changes".  Executed on Azure benchmark VM:
+
+++++++++++++++ results summary +++++++++++++++
+                                        |   pg9-large   |
+FindStudyByPatientId0Results            |       3.51 ms |
+FindStudyByPatientId100Results          |     381.67 ms |
+FindStudyByPatientId1Result             |       7.50 ms |
+FindStudyByPatientId5Results            |      22.51 ms |
+FindStudyByStudyDescription0Results     |       3.49 ms |
+FindStudyByStudyDescription1Result      |       7.36 ms |
+Startup time                            |     106.51 ms |
+Statistics                              |       3.36 ms |
+ToolsFindPatientByPatientID             |       5.11 ms |
+ToolsFindStudyByStudyInstanceUID        |       5.34 ms |
+UploadFirstPatientFile                  |      19.66 ms |
+UploadLargeFile10MB                     |      49.07 ms |
+UploadNextPatientFile                   |       9.07 ms |