Hi all,
I am developing a Web Service application on .NET 4.0. with VB.NET. using System.Data.ODB C as the data connector to Oracle 10G database.
Somehow i need to perform some updating and insertion of accounts information by batches into database. Thus, i used an odbcTransaction object to commit or rollback the updating/insertion in batches as well. In some scenarios, i would be having about 1000 SQL statement in a single odbcTransaction , i am wondering does this matter cause i can't predict the volume of data in actual production environment the Web Service would need to process.
Thank you in advance for replying my post.
regards,
prime
I am developing a Web Service application on .NET 4.0. with VB.NET. using System.Data.ODB C as the data connector to Oracle 10G database.
Somehow i need to perform some updating and insertion of accounts information by batches into database. Thus, i used an odbcTransaction object to commit or rollback the updating/insertion in batches as well. In some scenarios, i would be having about 1000 SQL statement in a single odbcTransaction , i am wondering does this matter cause i can't predict the volume of data in actual production environment the Web Service would need to process.
Thank you in advance for replying my post.
regards,
prime