Subject | Re: Odp: [firebird-support] Firebird 2.5.3 SS Tuning |
---|---|
Author | Mark Rotteveel |
Post date | 2014-09-19T09:05:34Z |
On Fri, 19 Sep 2014 01:22:31 -0700, "Tiziano tmdeveloper@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
Adding more RAM is not very useful if you are not going use it. Especially
with SuperServer with a small page buffer and a small page size, the only
effect of more memory is that more of the database might be in the
filesystem cache. If the server is 32 bit as you seem to imply, then there
is not a lot of use in increasing memory beyond 4 GB.
nothing to do with cluster size of your hard disk (although potentially it
might influence performance if they are the same, I wouldn't count on that
as most disk are already read in multiple clusters at once). In general I'd
use 16K pages, but your mileage may vary.
Mark
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Thank you for answer.RAM).
> For 16Gb or 64Gb RAM I don't if it is possible with current server
> (physical server limits I mean), I'll ask to customer (I hope in 8Gb
Adding more RAM is not very useful if you are not going use it. Especially
with SuperServer with a small page buffer and a small page size, the only
effect of more memory is that more of the database might be in the
filesystem cache. If the server is 32 bit as you seem to imply, then there
is not a lot of use in increasing memory beyond 4 GB.
> Anyhow, with dbbuffers you mean Page Buffers, right? Anda
> dbpagesize*dbbuffers=bytes used for cache, you mean total bytes for all
> connection or bytes for each connection?
> Another doubt (I found it in some forums but I don't remember the link),
> 16k page includes a 16k hard disk cluster (format options I mean)? It'sNo, the page size is the size of data pages in the database. It has
> correct?
nothing to do with cluster size of your hard disk (although potentially it
might influence performance if they are the same, I wouldn't count on that
as most disk are already read in multiple clusters at once). In general I'd
use 16K pages, but your mileage may vary.
Mark