Hi All,
I wanted to know how much faster 3.0 is than 2.5 and 4.0 than 3.0. Tried
to compare performance of 2.5, 3.0 and 4.0 with Firebird's OLTP solution
(executed ~100 times). The results are constant for me. 3.0 is slower
than 2.5 and 4.0 is slower than 3.0. (Some numbers published in the
"Some OLTP numbers" thread.) But I not trust in this OLTP's results
because with the same case AVG_TIMES_PER_MINUTE sometimes 5000 sometimes
6700 etc. So I started working on a TPC-E based solution. Made the
database script and the importer which load EGenLoader's txt files into
it. Then made an import comparison with limited number of tables and
limited row numbers between 2.5, 3.0 and 4.0. The result is 3.0 slower
than 2.5 and 4.0 slower than 3.0. Again and again and again. I know a
Firebird developer trust only in an ISQL case. So tried with it an got
same result.
The ISQL case is. I made a new database (CREATE DATABASE
'R:\DB\INSERT_TEST.FDB' PAGE SIZE 8192;) with 2.5, 3.0 and 4.0. Then
execute a one table script on it with ISQL (isql.exe -u SYSDBA -p
masterkey 192.168.0.99:R:\DB\INSERT_TEST.FDB -i DATA.sql). Executed this
three times per each Firebird version and the numbers are (+/- 1 second):
2.5 - 2:59 - 65.65 MB
3.0 - 3:27 - 68.95 MB
4.0 - 3:37 - 68.95 MB
2.5's conf:
DefaultDbCachePages = 50000
TempCacheLimit = 209715200
3.0's conf:
DefaultDbCachePages = 50000
TempCacheLimit = 200M
WireCrypt = Disabled
4.0's conf:
DefaultDbCachePages = 50000
TempCacheLimit = 200M
WireCrypt = Disabled
I used Win64 and SuperServers (2.5.9.27126, 3.0.5.33086, 4.0.0.1378).
The database placed on an NTFS ramdisk.
Any idea why I got same performance directions from months with
Firebird's OLTP, self made TPC-E importer and with ISQL too?
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
