updating data record by record or updating a whole Datatable in web-based application?

Question

Hi all. in web-based application, which method is prefered? I also need some examples about this issue.

Thanks in advance.

Answer 1

This really varies between all different cases. You can't expect a general and correct answer to this question. Different measures for different needs, etc.

Answer 2

If you're going to update a large number of records then it would be advisable to use bulk/batch updates. Modern database systems support special bulk update facility. The main benefit of using bulk updates is high performance. Bulk update facility generally reduces the amount of data being transmitted across the the network and does a number of optimizations for multiple record updates.