MSDENumberOfInsertsPerBatch Property of the IFPCLogs Interface

Article
08/13/2010

The MSDENumberOfInsertsPerBatch property gets or sets the number of SQL INSERT statements that are buffered before writing the information to a Microsoft SQL Server Desktop Engine (MSDE) log.

C++

HRESULT put_MSDENumberOfInsertsPerBatch(
    long lBufferSize
);
HRESULT get_MSDENumberOfInsertsPerBatch(
    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 an MSDE log.
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 an MSDE log.

Return Value

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

Visual Basic

Property MSDENumberOfInsertsPerBatch 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 SQL Server Express log.

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.

This property is deprecated in Forefront TMG. Use IsaDatabaseNumberOfInsertsPerBatch instead.

Requirements

Client	Requires Windows 7 or Windows Vista.
Server	Requires Windows Server 2008 R2 or Windows Server 2008 x64 Edition with SP2.
Version	Requires Forefront Threat Management Gateway (TMG) 2010.
IDL	Declared in Msfpccom.idl.
DLL	Requires Msfpccom.dll.

Share via