>>> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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