Salesforce

Opening queries causes srt file to grow were comparable FOR EACH statement does not

« Go Back

Information

 
TitleOpening queries causes srt file to grow were comparable FOR EACH statement does not
URL NameP14650
Article Number000131564
EnvironmentProgress 9.x
OpenEdge 10.x
All Supported Operating Systems
Question/Problem Description
Opening queries causes srt file to grow were comparable FOR EACH statement does not
Using a query to sequentially read a large number of records
Loop fetching records via query runs slower than a comparable FOR EACH loop
srt client temp-file grows to large size
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
This is expected behavior.

Unlike the FOR EACH statement, queries have the possibility to be navigated backwards and to be repositioned to specific records. To support this behavior, queries have to maintain a result list, which will be stored in the srt file if it can't fit in memory.

The size of the result list is directly related to the number of records that match the query criteria.
Resolution
Starting with the Progress 9.1D05 and OpenEdge 10.0A releases, the use of result lists for queries can be suppressed by using the FORWARD-ONLY attribute of the query.
Workaround
Notes
To help reduce the srt file growth ensure that all queries are closed when they are no longer needed as any space used by the query in the srt file will then be reused.
References to Written Documentation:

Progress Solutions:
P18639, How can I reduce the size of the .SRT file in Progress?
Keyword Phrase
Last Modified Date9/13/2015 3:49 PM

Powered by