Subject RE: [firebird-support] question about the FB superserver cache
Author Puigsegur, Jordi
> > We have a ~2 Gig database which acts as a cache of information
behind a
> > busy webpage. This database is read-intensive + some inserts. We
> > been gradually increasing the number of cache pages (i.e. the
> > firebird.conf file: DefaultDbCachePages = 50000). So far each
> > has turn out in a performance improvement. We would like to know how
> > can we keep increasing this parameter and experience performance
> > improvement? We run FB 2.0 on Windows 2K3, with lots of memory
> > available (obviously that is a limit). Since we use 4Kb. pages the
> > process occupies ~200 Mb.
> >
> I would increase the page size to 16k the maximum size of cache is
> pages if I recall correct.

I've been told that all windows Server 2003, 2003 R2 and 64 bits come
with a cluster size of 64K by default (and it is also the minimum
value). If that is true then it seems obvious that increasing the page
size to 16K might increase the performance (in the end it would depend
on the usage of the database).

Since we use blobs, depending on the size of the blobs we might be
wasting more space on disk, but gaining on performance.