Hi. If someone is interested, now i have compared 3 version of Firebird. The results are promissing as FB4 is the fastest, next FB3. The slowest is FB2.5 – no surprise for me in SS.
My numbers for settings: MEDIUM_03 50000 docs start FW synch 48 isql SuperServer For FB2.5 i use CpuAffinityMask = 63 WI-V2.5.9.27119 Firebird 2.5 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 180 minutes: 2106.71 40679 379208 2018-10-29 00:13 2018-10-29 03:13 WI-V3.0.5.33075 Firebird 3.0 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 180 minutes: 3968.06 16426 714251 2018-10-28 20:00 2018-10-28 23:00 WI-T4.0.0.1249 Firebird 4.0 Alpha 1 ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 180 minutes: 4547,94 15714 823177 2018-10-29 23:59 2018-10-30 03:00 Regards, Karol Bieniaszewski
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel