| Subject | Re: [firebird-support] Frequntly "index page error" |
|---|---|
| Author | Anderson Farias |
| Post date | 2009-05-03T13:42:50Z |
Hi,
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
>ass$predoc (i have over 450 active tale in this case)I don't know about your problem but I do know you must fix your buffers
>maximum number of user : 45
>my server : firebird 2.1.2 classic server
> page size : 4096
> buffers : 8192 : 32768 KB
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