Subject | Re: [firebird-support] Re: Performance tuning large FDB |
---|---|
Author | Daniel Rail |
Post date | 2006-01-20T13:31:36Z |
Hi,
At January 20, 2006, 4:27 AM, Ali Gökçen wrote:
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)
At January 20, 2006, 4:27 AM, Ali Gökçen wrote:
> <jan.bakuwel@i...> wrote:And for Classic it's preferable to have it less than 1,000.
>>
>> 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)
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)