> >If you have a page size of 8KB and a cache of 8192 pages, you will need
> >64MB RAM (plus some small fixed "overhead"). If you have to
> databases like
> >this opened, you'll need twice the RAM.
> >With IB/5.6 (and earlier/later versions?) there was little (if
> anything) to
> >gain by increasing the cache much above 10000 pages, but YMMV.
>
> I just read the FireBird.conf it has a note that the superserver has a
> cache of 2048 per database so having a default as per Marathon 1024 per
> page and 2048 pages per database is 2MB per database, right?
>
> My current app is a simple app with low single user traffic then is this
> okay (ie. 2MB)?

The server cache has nothing to do with page size. The db page size reflects
the block os disk space reserved for pages of data (which is how the server
stores it's contents). The server cache is a measure of how much ram is
allocated to it's cache for server operations. Don't get the two mixed up.

Alan