.NET provider

Connectivity
Enthusiast

.NET provider

I am working with the .NET provider (1.1.0.0). I am reading a file into a dataset that was created with a data adapter and performing an Update command. I have been playing around with the UpdateBatchSize property to get the best results. The default, 0, says send as many commands as the system will allow at one time. Any idea what that number actually is? Is there a preferred number to set it?

R
4 REPLIES
Teradata Employee

Re: .NET provider

.NET Data Provider sends a message to Teradata Database. Message has physical limits (e.g. size of the message and/or size of the parcels).

In another word, number of rows packed into a a message is dependent on the rows size and message limits. Therefore it really depends on the actual data.

DataAdapter generates events; you might be able to capture the events and figure out how many rows are packed into each and every message.
Enthusiast

Re: .NET provider

Thank you. That makes sense. Do you know what the limit on the size of the message is, or where I can find out the size.?

R
Teradata Employee

Re: .NET provider

It is around 1MB for Teradata database 6.x.
Enthusiast

Re: .NET provider

Thank you.

R