Home > Back-end >  How to increase the speed of the ApplyUpdates?
How to increase the speed of the ApplyUpdates?

Time:10-07

SimpleDataSet1. Edit;
SimpleDataSet1. Append;
SimpleDataSet1. FieldByName (' Mail '). AsString:='22 @qq.com
SimpleDataSet1. ApplyUpdates (0);//Append slow, it takes time to 1 second 6

If it is, after the modification of data ApplyUpdates fast,
After a new data, the ApplyUpdates, speed is slow, need time to 1 second 6,
There is no other way to quickly add data,

CodePudding user response:

CodePudding user response:

1, check the database table design, which is indexed field? How big is the form?
Because the index set up properly, may lead to the performance of the new data,
2, does not recommend applyupdates every time, can reach a certain amount, then the update; Remember that there is such a set clientdataset, specific what is forgotten - didn't touch this stuff for years,

CodePudding user response:

Clientdataset. Judge clientdataset afterpost event. Changecount> 20 then clientdataset. The apply...
  • Related