Al,
>>Per your suggestion about table buffering, I switched the RVs to use optimistic row buffering (=3) instead of the default optimistic table buffering (=5). AFAIK those are the only two settings that are valid for RVs.
>>Results:
>>Table buffering: 7:49
>>Row buffering: 8:07
I'd presume this is to do with the overhead of multiple writes needing another transaction and log every time, while table buffering and its database log are much more efficient than usual when appending into an empty table. Just for interest, do you have it in differential or complete mode?
>>One thing that does make a (literally) big difference is the SQL Server recovery mode for the databases...
Certainly a joyous experience when the full recovery model hogs everything in sight! At least you have the privilege of changing it. ;-)
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
