Subject | Re: Frequntly "index page error" |
---|---|
Author | mnavahan |
Post date | 2009-05-04T01:03:03Z |
--- In firebird-support@yahoogroups.com, "Anderson Farias" <peixedragao@...> wrote:
>but think is must not faild the database ! (but not sure)
> Hi,
>
> >ass$predoc (i have over 450 active tale in this case)
> >maximum number of user : 45
> >my server : firebird 2.1.2 classic server
> > page size : 4096
> > buffers : 8192 : 32768 KB
>
> I don't know about your problem but I do know you must fix your buffers
> setting. Using 32Mb for each connection is not of any value to your app and
> may lead to problems (maybe even the one you are experiencing).
>
> Usually, you should set buffers for CS between 50 and 500 even if you have
> plenty of memory. AFAIK this cache must be in sync between processes then,
> bigger caches leads to more work to the engine.
>
>
> Regards,
> Anderson Farias
>