In a big transaction, needs to be updated with the update about 1 million records, each updated data through a pile of calculation rule processing, so not a batch update
Update a few records in front of the time very fast (less than 1 millisecond), but with the passage of time, the update execution time longer and longer, finally to 100 milliseconds
What reason is this?
Update to update with the primary key, about 10 fields are updated. The whole table only 15 fields, the remaining five with primary key
Basic statement like this:
The update table set

Field1=XXX,
Field2=XXX,
Where key1=... Key2=XXX... Key5=XXX.
SQL Server is 2014

CodePudding user response:

With q, similar scenes, I use the PostgresSQL, update the data in circulation, a federated query will update more table is updated again, slowly at first, change the database buffer after big, speed faster, but after a period of time, gradually slow down, now also don't know what reason