Is it a best practice to perform Normal or Batch Insert/Update/Delete operations on a back end database as part of a Scheduler service from webMethods.
Each time when the Scheduler service runs it will insert about a volume of >10K records in a table.
If we perform this operation with a high volume will there be a risk of a Lock on the table getting applied because of the webMethods transaction.I am currently facing this issue in of my current assignment.
Thanks in Advance!!