On 2/8/22 12:23, Jiří Činčura wrote:
First of all DPB, but conf files are also interesting.
DPB:
isc_dpb_dummy_packet_interval => 120
dummy packet interval makes no sense for embedded
do not think that affects result - just strange
isc_dpb_sql_dialect => 3
isc_dpb_user_name
isc_dpb_set_db_charset
isc_dpb_force_write => 0
isc_dpb_overwrite => 1
isc_dpb_page_size => 16k
Config file is whatever is default as there's no explicit config file.
Retried your test, using isql in this way (linux x64):
time (echo "CREATE DATABASE '/mnt/db/xxx.gdb' PAGESIZE 16384;" | ./isql)
/mnt/db is on sata SSD
Resuting time is 0.086s for fb4 & 0.038s for 2.5. I.e. 4 is twice
slower. But please compare database sizes:
fb4: 3162112
fb2.5: 2359296
I.e. approximately half of a difference is due to more complex (and
therefore bigger) database. The rest may depend on a lot of things - up
to other ICU version or additional time for separate provider loading.
Do not see it as critical.
I compared what I get with your result:
0.042s (on average on my machine) on FB 2.5, but 0.162s on FB4
Almost 4 times slower is definitely hard to explain with 1.35 times
bigger DB size, no idea why does it run so slow for you.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
