Subject Re: [firebird-support] Have a lots memory, but FB could not take advantages
Author Doug Chamberlin
What are you seeing that makes you think your goal has not already been met?


On Mon, Jul 15, 2013 at 12:38 PM, trskopo <trskopo@...> wrote:

> 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
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]