Hi,

At January 20, 2006, 9:19 AM, Jan Bakuwel wrote:

> Hoi Ali,

> Wouw, you respond quickly! :-)

>> FB has not any sort file size paramater if i know correctly, and
>> not required.
>>
>> These config paramaters and sort in RAM, written and added by
>> D.Yemanov a few years ago.

> I don't understand. These are not FB parameters?

They are. Prior to Firebird 1.5, if sorting was needed it was done on
disk. Now, Firebird will try to use the memory before using the disk.

> They are in the FB
> config file... (and seem to have an effect on the amount of memory FB
> allocates)?

And they do affect the memory allocation. And, for Classic the memory
allocation is per connection, while for Superserver that allocation is
per database(no matter how many connections). And, having more than
10,000 page cache will actually reduce your performance, because of
how the code was written, but I think that has been improved for
Firebird 2.

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