Subject | Re: [firebird-support] Re: Memory use and FB 1.5 |
---|---|
Author | Gary Benade |
Post date | 2004-06-30T11:48:47Z |
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
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