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


Adriano


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to