[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DB Crash: Out of free shared memory. Use -Mxs to increase

  • Thread starter Thread starter ChUIMonster
  • Start date Start date
Status
Not open for further replies.
C

ChUIMonster

Guest
Using ONE BIG DB TRANSACTION for bulk deletes is asking for trouble. Bulk delete operations are almost always very easy to restart and make excellent candidates for breaking into smaller transactions. You might also want to test the performance of deleting a large number of records in a single transaction vs deleting one record at a time.

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