Subject Re: [firebird-support] Re: GEN_UUID performance
Author Thomas Steinmaurer
>>> What was the size of the page cache?
>> The default one. I simply created a new database without any tuning
>> measures.
>>> Does performance change if you increase the page cache?
>> Yes, it does. Thanks. ;-)
> By how much?
> What size(s) have you tried?

I don't have the exact numbers here right now, but from ~ 50 minutes
execution time with a default page cache of 75, down to ~ 30 seconds (!)
with a page cache of 10.000. This was SuperClassic and the only
connection in this test case, thus the high page cache in that scenario
with SuperClassic.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!