Kbase P12768: Performance issue when trying to find the last record in a SmartDataObject
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/02/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Attempting to navigate the SmartDataObject's query from the first record to the last
Poor performance when moving to the last record in the SmartDataObject
SmartDataObject is built off of a large database table (over 10,000 records, for instance)
The number of rows to batch (RowsToBatch) in the SmartDataObject is set to a reasonable value
CAUSE:
The 'Rebuild Dataset on Reposition' property of the SDO is turned off
FIX:
Set the SmartDataObject's 'Rebuild Dataset on Reposition' property to true. e.g.:
DYNAMIC-FUNCTION('setRebuildOnRepos':U IN <SDO-Handle>,
INPUT TRUE /* LOGICAL */).