Hi Adriano, > Arno, can you please verify now? > It should still reset the array, but much less than before.
Yes!, this makes a big difference, for my sample the speed difference between FB2.5 and FB3.0 now dropped from 125x to 3x slower for "prepare time". I've been looking at the code to, but what makes me wonder is what causes the list to be invalidated? According to your "workaround" something is added in the front. Is this done by parse.cpp ? Beside all this, i got the feeling that it is unneeded to always make a copy of all nodes in items to jrdChild and dsqlChild. Next to it, it is very easy to mess around directly with ValueListNode.items cause it's public? Very happy to see that the source has certainly improved in readability and using OOP, so good work to all firebird developers here. I'll do some more profiling and investigation and see what i can find here. Kind Regards, Arno Brinkman ABVisie ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel