19.01.2019 23:14, Gabor Boros wrote:
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):
This is a single-threaded test, isn't it?
2.5 - 2:59 - 65.65 MB 3.0 - 3:27 - 68.95 MB 4.0 - 3:37 - 68.95 MB
The results are more or less expected in this case (it doesn't mean they're desirable but this is a different story).
However, TPC-C and OLTP-EMUL are multi-threaded tests and this is exactly the scenario where v3/v4 are expected to win.
Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel