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 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 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

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/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

[Firebird-devel] Compiled statement cache

2022-02-08 Thread Adriano dos Santos Fernandes
Hi! I have refactored DSQL statements/requests (continued worked of many time ago) to separate shared (statement) and specific (request) parts. It seems this ground work for compiled statement cache is complete and I have even did a (very very) initial version of a compiled statement cache

Re: [Firebird-devel] Compiled statement cache

2022-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/22 16:36, Adriano dos Santos Fernandes wrote: Hi! I have refactored DSQL statements/requests (continued worked of many time ago) to separate shared (statement) and specific (request) parts. It seems this ground work for compiled statement cache is complete and I have even did a (very