Subject Re: [firebird-support] Re: Memory use and FB 1.5
Author Gary Benade
Michael

How many cache buffers have you allocated for the server?
I see the page buffer count is 0 in your header stats, so the database is
using the global default for the server stored in firebird.conf which is
2048. Have you modified the conf file in any way?

I would suggest running gfix to set the buffers for that particular database
to a known value as a starting point, just so you know where you stand. I
dont know your database, but a value of 10000 seems to work fine for me in
all my apps.

Another thing. Do you have an index on that table with a high number of
duplicates? Maybe you should post the index stats so we can have a look.

Regards
Gary