Hi, Result for Firebird 2.5 SuperClassic is amazing. And i do not know why FB3 here is not so fast? FB2.5 is the fastest. It do 2x more job then FB4. Interesting is also db size after. In FB 2.5 SuperServer it is ~5GB In FB 2.5 SuperClassic which do more job then any it is ~12GB But FB3 it is ~18GB and FB4 23GB!.
ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END *** OVERALL *** for 180 minutes: 10632.09 15809 1913777 2018-11-02 00:05 2018-11-02 03:05 Can someone tell me why so big difference? I nkow that this test is quite random but.. Regards, Karol Bieniaszewski ---------------------------------------------------------------------------------------------------- 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