| Subject | Re: [firebird-support] Table update performance dropped significantly within few days. |
|---|---|
| Author | |
| Post date | 2014-01-15T19:38:27Z |
Finally this isn't a Firebird bug is only a configuration issue.
Let me know if this solve your problem because you will need one more parameter ;)
Em 15/01/2014 17:36, <fabianoaspro@...> escreveu:
We had this same issue. We have a large table with much indices and some day all goes slow.
Reducing index quantity helped a lot.
We was using 90 pages of cache in Classic. We increased this number to 150, shutdown all conections and thats it! Problem solved.
Latter we increased this number to 2048 as Superserver default. Our big client has 140 active simultaneous connections and no problem. Of course we calculate the necessarie ram.