On 2/28/22 16:54, Adriano dos Santos Fernandes wrote:
On 26/02/2022 22:05, Adriano dos Santos Fernandes wrote:
I will report back some numbers (memory, prepare times).
Here is a performance test I did: https://pastebin.com/3UnB5BNU
It's relative simple (not much indices) and common metadata.
It's tested as whole (create database, create metadata, populate, run
queries and get results, drop database).
The last select has a statement size of 21.5KB.
For reference, "select 1 from rdb$database" has size 6KB.
Test timings:
- Without statement cache: 19800ms
- With statement cache: 16700ms
More than 10% is great!
I suppose it's with mentoned 2Mb cache.
One more question. Suppose some statement remains in a cache for very
long time cause it's reused again and again. That's fine - but with DB
grow optimal plan can change. Is it solved somehow? Suppose in first
implementation not, but are there plans to solve it?
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel