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

Reply via email to