>> Can you execute same SS (2.5 vs 3.0) tests with 5 ISQL sessions? I do not know what purpose for only 5 ISQL but here you are. As suppsed, more succesfull requests – smaller numer of conflicts as only 5 ISQL.
FB3 wins unquestionably. Server version: WI-V3.0.5.33100 Firebird 3.0 resulted database size: 21,8 GB (23 501 996 032) Records count: 151 178 165 FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE SuperServer 3.0.5 P:\DB\OLTP3.FDB ON 20000 262144 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 16158.17 653 969490 2019-02-14 17:54 2019-02-14 18:54 Server version: WI-V2.5.9.27127 Firebird 2.5 Resulted database size: 5,15 GB (5 531 705 344) Records count: 36 316 350 FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE SuperServer 2.5.9 P:\DB\OLTP2.FDB ON 20000 262144 8192 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 60 minutes: 6414.48 1786 384869 2019-02-14 19:56 2019-02-14 20:56 Regards, Karol Bieniaszewski
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel