Re: [Firebird-devel] ODP: ODP: Some OLTP numbers

2018-10-30 Thread Gabor Boros 

2018. 10. 30. 6:52 keltezéssel, Karol Bieniaszewski írta:

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
5 docs start
FW synch
48 isql
SuperServer

For FB2.5 i use CpuAffinityMask =  63



What platform? Windows server and Windows client?

Gabor


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] ODP: ODP: Some OLTP numbers

2018-10-29 Thread 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
5 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