Geeks With Blogs
Srijith Sarman Time,space and living January 2007 Entries
Bulk Update and Bulk Delete
Bulk inserting would not be a problem for most of the developers.Lot's of examples are out there. Simply bulk inserting in a transaction will do the purpose. Another common method is to call the DataAdapter.Update() method. Last day I stumbled a little ,when I test the time taken by the bulk delete and bulk update code which I have writtten. Each time ,the sql query which has a where condition kills the time.Also the operation was being done in a client side database (Had it been an enterprise database ......

Posted On Sunday, January 14, 2007 1:03 PM

Copyright © Srijith Sarman | Powered by: