Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Jiří Činčura
> 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

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Alex Peshkoff via Firebird-devel
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

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Jiří Činčura
> 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

Re: [Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-08 Thread Alex Peshkoff via Firebird-devel
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

2022-02-08 Thread Jiří Činčura
> 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

2022-02-08 Thread Alex Peshkoff via Firebird-devel
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

[Firebird-devel] Slower database creation on Embedded in 4.0 compared to 2.5

2022-02-07 Thread Jiří Činčura
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