Request to provide row status array when doing array inserts with EnableBulkLoad set on.

  • Thread starter Thread starter Tim Kirwan
  • Start date Start date
Status
Not open for further replies.
T

Tim Kirwan

Guest
- Reason for request: When the customer enables bulk processing and uses array inserts the driver treats the insert as an atomic operation, so that if any rows fail, all fail. This is different than the driver behavior for array inserts without EnableBuldLoad set on. This results in many insert operations not being able to take advantage of the benefits of bulk load when the expectations are that the performance will be increased by using the EnableBulkLoad setting. Additionally, the driver may determine at times to not use bulk processing even with EnableBulkLoad set on, due to a number of reasons, and when this is the case, the results are inconsistent with the behavior for the times when the driver does determine to use bulk processing. - Possible workarounds: No alternatives or workarounds exist for this request.

Continue reading...
 
Status
Not open for further replies.
Back
Top