| Subject | Re: [firebird-support] Table update performance dropped significantly within few days. |
|---|---|
| Author | |
| Post date | 2014-01-15T18:41:15Z |
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.
Em 15/01/2014 16:30, <brucedickinson@...> escreveu:
Hi guys.
I have one table that currently has 100 000 000 records. PageSize is 16384.
Index statistics for primary key are 0.000000 (I've recomputed them).
Over a few days inserting and updating this table slowed down significantly. When I try to update one row:
UPDATE TABLE SET VALUE=X WHERE PK_COLUMN_ID =12335343
update executes in 0.250 miliseconds.
What is surprising for me that just few days ago everything was fine.. how could I speed thing up? What could happen over these few days?
Thanks in advance.