SQLNumberOfInsertsPerBatch Property of the IFPCLogs2 Interface

The SQLNumberOfInsertsPerBatch property gets or sets the number of SQL INSERT statements that are buffered before writing the information to a log stored in a SQL Server database.

C++

HRESULT put_SQLNumberOfInsertsPerBatch(
    long lBufferSize
);
HRESULT get_SQLNumberOfInsertsPerBatch(
    long* plBufferSize
);

Parameters

• lBufferSize
  A 32-bit integer value that specifies the number of SQL INSERT statements that are buffered before writing the information to a log stored in a SQL Server database.

• plBufferSize
  Pointer to a 32-bit integer that is set on return to the number of SQL INSERT statements that are buffered before writing the information to a log stored in a SQL Server database.

Return Value

These property methods return S_OK if the call is successful; otherwise, they return an error code.

Visual Basic

Property SQLNumberOfInsertsPerBatch As Long

Property Value

A 32-bit integer that specifies the number of SQL INSERT statements that are buffered before writing the information to a log stored in a SQL Server database.

Remarks

This property is read/write. Its default value is 10,000, and its range of permissible values is from 1 through 100,000. In common scenarios, there is no need to deviate from the default value.

Requirements

See Also

FPCLogs

Send comments about this topic to Microsoft

Build date: 6/30/2010