Why to use bulk insert activity that is coming with new database. activities?

Help Studio
, ,
2

Hello @ydash999

Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database.

One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data.

But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert to insert all the data to DB in a single call to database .

2 Likes