By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,608 Members | 1,925 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,608 IT Pros & Developers. It's quick & easy.

Maximum buffer size of an odbcTransaction object in .NET 4.0

P: 35
Hi all,
I am developing a Web Service application on .NET 4.0. with VB.NET. using System.Data.ODBC 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
Sep 20 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.