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

In This Topic
    UpdateBatchSize Property
    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
    public int UpdateBatchSize {get; set;}

    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