sql server - DataSet Performance -


could explain me why there such difference when comes filling , updating dataset? working on program takes data 1 db , puts them second db. original db contains quite lot of data. wonder why fast program fill dataset data, long update.

code schema looks that:

create connections; openconnections(); create dataadapter1, dataadapter2; create commandbuilder1, commandbuilder2; create dataset; dataadapter1.fill(dataset, connection1); dataadapter2.update(dataset, connection2); closeconnections(); 


Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -