Kbase P61398: SDO poor performances in client server with large amount of Data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10
SYMPTOM(s):
ADM2. SDO poor performances in client server with large amount of Data when repositionning to a specific record.
Rebuild dataset on Reposition
SDO poor performances in client server with large amount of Data
FIX:
Check Rebuild DataSet on Reposition In the SDO Instance Properties.
Choose to rebuild the temp table starting with the specified record.
When a record is requested that is not in the 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.
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.