Subject Re: [firebird-support] memory usage
Author Helen Borrie
At 10:12 AM 26/07/2004 +0000, you wrote:
>(Using Firebird-SS 1.5.1 / Linux)
>We use Firebird on am embedded platform running linux on compact flash
>with very few memory (128MB).
> . There is only 1 database (Page size=4096)
> . There are allways 3 opened connections
> . The default settings from firebird.conf are used
>For now, fbserver is using (according to 'top') about 10% of the whole
>. Should some settings be changed in firebird.conf for this special
>use of firebird?
>. Particularly, is it recommanded to reduce DefaultDbCachePages to 1024 ?
>. To which value should be set 'SortMemUpperLimit' (currently 64MB,
>which seems too high for a system with so few memory)
>. What happens if fb runs out of memory because of to lower values in

You can happily reduce the sort memory limit or even set it to
zero. Firebird will then revert to its long-established practice of doing
all sorts in temporary disk files.

Can't work out what you mean by "embedded platform on Linux" if you are
using Superserver with three concurrent users...

But there would be no harm in reducing the cache size. There's absolutely
no point in maintaining a large cache relative to available RAM if the
caching has to thrash the disk, is there?