Kbase P6929: When should Rebuild DataSet on Reposition option be turned off for a SmartDataObject?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
When should Rebuild DataSet on Reposition option be turned off for a SmartDataObject?
FIX:
In Progress the default value of Rebuild Dataset on Reposition is set to false for backward compatibility, although it should be set to true for large datasets. In WebSpeed the default value of Rebuild Dataset on Reposition is set to true.
When a record is requested that is not in the rowObject client temp table, the default behavior of Progress is to rebuild the temp table from the beginning of the dataset. When the Rebuild Dataset on Reposition box is checked (set to true), the temp table is rebuilt starting with the specified record. This greatly improves performance for large datasets.
At last, this property should be intentionally set to false for small datasets in tables that manage rather static data, in order to avoid unnecessary rebuild of batches.