Kbase P6890: Performance is slow when using the GET LAST function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/10/2002 |
|
Solution ID: P6890
FACT(s) (Environment):
DataServer
SYMPTOM(s):
Performance is slow when using the GET LAST function
NUM-RESULTS returns total number of records
CAUSE:
The GET LAST function causes the client to process all of the records.
FIX:
This is an expected behavior. Use FIND LAST instead. The FIND LAST statement allows the server to retrieve the last record.