Subject Re: [firebird-support] Re: Performance tuning large FDB
Author Daniel Rail
Hi,

At January 20, 2006, 4:27 AM, Ali Gökçen wrote:

> <jan.bakuwel@i...> wrote:
>>
>> Relevant Firebird parameters in /etc/firebird2/firebird.conf
>>
>> DefaultDbCachePages = 819200
>> SortMemBlockSize = 1073741824
>> SortMemUpperLimit = 4294967296

> This parameters will be ignored FB or any 32bit application.
> 819TonePages are out of range. (<10,000 suitable for <=FB1.x)

And for Classic it's preferable to have it less than 1,000.
You have to remember that for classic these settings are per
connection, compared to Superserver where those settings are per
database and that memory space is shared with all the connections to a
database.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)