Kbase 16613: One way to speed up mass DELETE after reporting ( archive )
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
One way to speed up mass DELETE after reporting ( archive )
Frequently, there is a need to report or archive data stored in a
large group of records (such as for a fiscal period), and then
remove all the reported or archived records from that database.
Rather than fetching the records twice, the recids can be stored
in a workfile or temp-table during the reporting phase and used
in the deletion phase. So, instead of a FOR EACH... WHERE... DELETE,
a statement such as FIND <table> WHERE RECID<table> = temptab.recid
can be used. This will result in a significant performance gain
during the deletion process.
Progress Software Technical Support Note # 16613