On 10/02/2022 10:04, Dimitry Sibiryakov wrote: > Adriano dos Santos Fernandes wrote 10.02.2022 13:56: >> But it's not surprise that many applications are not well coded and >> sometimes does not do this. Competitor DBMSs has cache and works well in >> this case too. > > Such applications used to build the queries ad-hock with data as > literals.
Some times yes, some times no (it's identical statement reprepared or executed). > The competitors has a way to forcefully parameterize such > queries and without it the cache is useless because every query is > different. > Yes, this is possible and some do it. But I do not see it in the scope of a first version. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel