D
dbeavon
Guest
@bremmeyr - I think OE-SQL92 came to mind when I saw those related comments on this thread : community.progress.com/.../8292 I have used OE-SQL92 quite a bit and it often performs better than ABL for bulk operations; I assume deletes are no different. For one, the technology can leverage a different set of concurrency/isolation modes and locking levels (even up to locking the entire table if appropriate). Additionally I'm guessing that it can batch up and pipeline the various units of work (eg. index deletions) in a way that is unlike than what an individual ABL DELETE row statement would do. Finally, in SQL92, a large deletion statement can be processed entirely within native, non-custom code without any AVM which, provided that is part of the bottleneck, would be a huge benefit on the CPU side of things. I still have some hope for my ABL deletion program. Especially if I can find more silver bullets like the -spin change.
Continue reading...
Continue reading...