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 -

python - ValueError: could not convert string to float -

php - Laravel Get all child node count with condition -