Subject | Re: Memory use and FB 1.5 |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-06-30T11:52:22Z |
> 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 thedatabase is
> using the global default for the server stored in firebird.confwhich is
> 2048. Have you modified the conf file in any way?No
>database
> I would suggest running gfix to set the buffers for that particular
> to a known value as a starting point, just so you know where youstand. I
> dont know your database, but a value of 10000 seems to work finefor me in
> all my apps.I'll have a look at this.
But this havn't been a problem prior !
>number of
> Another thing. Do you have an index on that table with a high
> duplicates? Maybe you should post the index stats so we can have alook.
I'll dump the indeks stats tonight.
Michael