Wednesday, March 21, 2012

Question about IRowsetFastLoad::Commit(FALSE)

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 Rowsets
What 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