| Subject | Table update performance dropped significantly within few days. |
|---|---|
| Author | |
| Post date | 2014-01-15T18:30:07Z |
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.
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.