Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-13 Thread Adriano dos Santos Fernandes
On 13/03/2019 17:04, Vlad Khorsun wrote: > >   Sorry, it is still not clear - how one could know if node requires > "specialization" ? > Imagine a new developer who want to create new kind of Nodes - what is > formal > criteria of "specialized" node ? > >   Currently it could be detected by retur

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-13 Thread Vlad Khorsun
13.03.2019 2:37, Adriano dos Santos Fernandes wrote: On 12/03/2019 17:22, Vlad Khorsun wrote: Let me demonstrate it. With this (wrong) patch now the code compiles: -- diff --git a/src/dsql/ExprNodes.cpp b/src/dsql/ExprNodes.cpp index 4ff5253a2b..26f826ae09 100644 --- a/src/dsql/Ex

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-12 Thread Adriano dos Santos Fernandes
On 12/03/2019 17:22, Vlad Khorsun wrote: >> >> Let me demonstrate it. With this (wrong) patch now the code compiles: >> >> -- >> diff --git a/src/dsql/ExprNodes.cpp b/src/dsql/ExprNodes.cpp >> index 4ff5253a2b..26f826ae09 100644 >> --- a/src/dsql/ExprNodes.cpp >> +++ b/src/dsql/ExprNod

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-12 Thread Vlad Khorsun
12.03.2019 17:24, Adriano dos Santos Fernandes wrote: On 11/03/2019 09:35, Vlad Khorsun wrote:   I just committed few patches and have few more things to ask here: Vlad, the change just broke reason for NodeRef/NodeRefImpl existence (which is still commented but not working): // This class

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-12 Thread Adriano dos Santos Fernandes
On 11/03/2019 09:35, Vlad Khorsun wrote: > >   I just committed few patches and have few more things to ask here: > Vlad, the change just broke reason for NodeRef/NodeRefImpl existence (which is still commented but not working): // This class and NodeRefImpl exists for nodes to replace themselves

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-11 Thread Vlad Khorsun
07.03.2019 13:45, Adriano dos Santos Fernandes wrote: On 07/03/2019 06:52, Vlad Khorsun wrote:   Database creation time mostly contains from compiling and parsing requests. Unfortunately, it is slower in fb4 than fb3 and fb3 is much slower than fb25. IIRC, it was said here sometime ago and som

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-11 Thread Vlad Khorsun
08.03.2019 17:22, Mark Rotteveel wrote: On 7-3-2019 10:52, Vlad Khorsun wrote: ... PS i see how to make database creation faster (by reusing compiled statements whenever possible), but it will not solve general problem with compiation time. Is this something that could be improved with profil

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-08 Thread Mark Rotteveel
On 7-3-2019 10:52, Vlad Khorsun wrote: 05.03.2019 0:59, Vlad Khorsun wrote:    I can confirm it. First look show that request compilation is slower in fb4, i.e. it is general issue, not related with database creation directly. Investigating.   Database creation time mostly contains from comp

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-07 Thread Adriano dos Santos Fernandes
On 07/03/2019 06:52, Vlad Khorsun wrote: > >   Database creation time mostly contains from compiling and parsing > requests. > Unfortunately, it is slower in fb4 than fb3 and fb3 is much slower > than fb25. > IIRC, it was said here sometime ago and some improvement was made, but > it is > still slo

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-07 Thread Vlad Khorsun
05.03.2019 0:59, Vlad Khorsun wrote: 02.03.2019 14:25, Mark Rotteveel wrote: On 28-12-2018 17:44, Mark Rotteveel wrote: It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through org.firebirdsql.management.

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-04 Thread Vlad Khorsun
02.03.2019 14:25, Mark Rotteveel wrote: On 28-12-2018 17:44, Mark Rotteveel wrote: It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through org.firebirdsql.management.FBManager) takes roughly 200ms, while

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-02 Thread Mark Rotteveel
On 28-12-2018 17:44, Mark Rotteveel wrote: It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through org.firebirdsql.management.FBManager) takes roughly 200ms, while on Firebird 4.0.0.1352 it takes roughly

[Firebird-devel] Database creation slower in Firebird 4

2018-12-28 Thread Mark Rotteveel
It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through org.firebirdsql.management.FBManager) takes roughly 200ms, while on Firebird 4.0.0.1352 it takes roughly 300ms. Is this primarily due to increased