| Subject | Re: [firebird-support] Table update performance dropped significantly within few days. |
|---|---|
| Author | |
| Post date | 2014-01-15T20:01:12Z |
No.
Only when increased cache. Shutdown all conections because when they reconnect will use the new cache limit.
Em 15/01/2014 17:45, "Alexandre Benson Smith" <iblist@...> escreveu:
Em 15/1/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.
Maybe the problem was solved when you detached all connections because it closes the an old open transaction :)
see you !