Hi,
If I use IRowsetFastLoad::Commit(FALSE) not IRowsetFastLoad::CommitCommit(TRUE), are there any limitation of IRowsetFastLoad::InsertRow(..) before Commit(FALSE)?
Now, I'm using everlastingly InsertRow(..) and Commit(FALSE) method repeatedly. A few days after, it seems not to work.
Implicit commit depends on the batch size. This can be set by SSPROP_FASTLOADOPTIONS. See e.g. IRowsetFastLoad RowsetsWhat does not work for you?|||
The sqlserver.exe's memory usage increases up to 1G.
rgProps[0].dwOptions = DBPROPOPTIONS_REQUIRED;
rgProps[0].colid = DB_NULLID;
rgProps[0].vValue.vt = VT_BSTR;
rgProps[0].dwPropertyID = SSPROP_FASTLOADOPTIONS;//SSPROP_ENABLEFASTLOAD;
rgProps[0].vValue.bstrVal = L"ROWS_PER_BATCH = 10000,TABLOCK";
No comments:
Post a Comment