[progress Communities] [progress Openedge Abl] Forum Post: Re: Optimal Transaction Size To...

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

ChUIMonster

Guest
What version are you experimenting with? In the past my personal experiments have indicated that one record at a time works best for DELETE operations. Grouping transactions has appeared to hurt delete performance. Multi-threading does too. When grouping records for updates I have not noticed any consistently significant difference between 50, 100, 500 or 1,000 - so I usually just do 100.

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