Subject RE: [ib-support] FB1 Memory usage
Author Leyne, Sean
> Does Firebird have a problem with memory usage?

Yes and no!

Yes, it doesn't use a lot!

No, this used to be a good thing -- back in the days when 64MB of memory
was an LOT of RAM (I'll omit the visit to the stone age when 16KB was
the norm..)

> Are there any actions I can take or setting to be made to alter this
> characteristic.

Have a lot at the DATABASE_CACHE_PAGES entry in the "IBConfig." file.
First, make sure that the list doesn't start with '#', next set the
value to at least 2048 (if not more, although a value over 10,000 has
been reported as inefficient). The total memory used will be:
MEMORY_USED = DATABASE_CACHE_PAGES * PAGE_SIZE


Sean