dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteDataAdapter Class / UpdateBatchSize Property

UpdateBatchSize Property (SQLiteDataAdapter)
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 Overrides Property UpdateBatchSize As Integer
 

Property Value

The number of rows to process per batch.
Remarks
Value Meaning
0 The SQLiteDataAdapter will use the largest batch size that the server can handle.
1 Batch updating is disabled.
Greater than 1 Changes are sent using batches of UpdateBatchSize operations at a time.
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