Subject | RE: [ib-support] FB1 Memory usage |
---|---|
Author | Leyne, Sean |
Post date | 2003-01-30T15:34:03Z |
> 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 thisHave a lot at the DATABASE_CACHE_PAGES entry in the "IBConfig." file.
> characteristic.
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