dotConnect for PostgreSQL Documentation
Devart.Common Namespace / DbDataTable Class / UpdateBatchSize Property

In This Topic
UpdateBatchSize Property (DbDataTable)
In This Topic
Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.
Syntax
'Declaration
 
Public Property UpdateBatchSize As Integer
 

Property Value

The number of rows to process per batch. If 0, there is no limit on the batch size. If 1, batch updating is disabled. If more than 1, determines the amount of operations sent at once.
Remarks
Use the UpdateBatchSize property to update a data source with changes from a DbDataSet. This can increase application performance by reducing the number of round-trips to the server. However, executing an extremely large batch could decrease performance. You should test for the optimum batch size setting before implementing your application.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

DbDataTable Class
DbDataTable Members

 

 

© 2003 - 2025 Devart. All Rights Reserved.

Send Feedback