Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
> dummy packet interval makes no sense for embedded > do not think that affects result - just strange Yes, it's same code for wire protocol implementation as well as embedded. >> 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. I'm running on PCIe Gen 4 SSD and also on Windows/NTFS. Might affect the numbers. > Do not see it as critical. Fine with me. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
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
Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
> First of all DPB, but conf files are also interesting. DPB: isc_dpb_dummy_packet_interval => 120 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. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
On 2/8/22 11:27, Jiří Činčura wrote: Are you using default DB options? You mean DPB or settings in firebird.conf? First of all DPB, but conf files are also interesting. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
> Are you using default DB options? You mean DPB or settings in firebird.conf? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
On 2/7/22 13:52, Jiří Činčura wrote: Hi *, For some tests I'm creating and dropping a database for each test. Doing just that, it takes around 0.042s (on average on my machine) on FB 2.5, but 0.162s on FB4. Is this expected? Are you using default DB options? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5
Hi *, For some tests I'm creating and dropping a database for each test. Doing just that, it takes around 0.042s (on average on my machine) on FB 2.5, but 0.162s on FB4. Is this expected? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel