| Subject | Have a lots memory, but FB could not take advantages |
|---|---|
| Author | trskopo |
| Post date | 2013-07-15T16:38:40Z |
Hi all,
I have a 16GB RAM and since my database file is small size, it can completely runs on RAM.
The problem is I can not set FB SuperClasic 2.5.1 on WinXp 64 to take advantages of it.
Setting Page Size and Page Buffers is useless.
Performance seems just the same whether Page Size set to maximum (16384) or minimum (4096). Same with DefaultDbCachePages, I even set it to zero in firebird.conf.
When Page Size and Page Buffers set to minimum value, memory consumption for firebird server also minimum, without any decrease in performance.
Page Size and Page Buffers setting only useful when database file set on disk.
Any hints, how to take advantage these memory?
Thanks and regards
Anto
I have a 16GB RAM and since my database file is small size, it can completely runs on RAM.
The problem is I can not set FB SuperClasic 2.5.1 on WinXp 64 to take advantages of it.
Setting Page Size and Page Buffers is useless.
Performance seems just the same whether Page Size set to maximum (16384) or minimum (4096). Same with DefaultDbCachePages, I even set it to zero in firebird.conf.
When Page Size and Page Buffers set to minimum value, memory consumption for firebird server also minimum, without any decrease in performance.
Page Size and Page Buffers setting only useful when database file set on disk.
Any hints, how to take advantage these memory?
Thanks and regards
Anto