I can indeed confirm that using the BulkEntryTransaction mechanism
increases performance, in a quite spectacular way, to say the least. You
may expect your programs to run multiple times faster when using
BulkEntryTranasaction.
Thilo
Carey Matthew Black wrote:
Conny,
I agree that the structure of your client program is not drastically
changed by using this feature. I was commenting more on the
performance part of the original question.
To be clear, I am not doubting your understanding of this function. (
I have not had an opportunity to need to use it yet.) However, I was
under the impression that performance would be a reason to use this
feature.
I would hope that the RDBMS might benefit the most from this approach
by reducing it's needs to write to it's disk IO once instead of 1000's
of times.
Do you know if there is any performance gain by using
ARBeginBulkEntryTransaction to commit multiple records in one
communication to the AR Server vs not doing this?
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
