Subject Re: Memory use and FB 1.5
Author Michael Vilhelmsen
> How many cache buffers have you allocated for the server?

Default value.
I havn't modified anyhing.

> 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?
No


>
> 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.

I'll have a look at this.
But this havn't been a problem prior !

>
> 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.

I'll dump the indeks stats tonight.

Michael