| Subject | Re: [firebird-support] Table update performance dropped significantly within few days. |
|---|---|
| Author | Jesus Garcia |
| Post date | 2014-01-15T18:51:37Z |
2014/1/15 <fabianoaspro@...>
Increase database page buffers and try again.
It happens when you combine a large table with multiple indexes.
Dropping one or two indices can also increase speed a lot in this case.
I think, 100 million records are not so much records, and If you use classic or superclassic, pagebuffers cannot be high.
What firebird version?
How many indices has that table?
Do you update indexed fields?
May be the problem is Firebird performance with large indices.