Kbase P162188: Poor performance when querying two records, all other record look ups perform well.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Poor performance when querying two records, all other record look ups perform well.
4GL look up is taking too much time.
Other record lookup performance is fine.
Some Fields in the 2 records contain invalid data
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Application does not validate data entry. When numeric data is entered in a character field or visa versa, the data is accepted.
So when the data is processed the application is looping many iterations in some code sections working with invalid data.
FIX:
Identify the records and fields with bad data information and correct them.
The application should also be changed to check data type entries and value ranges to avoid this type of an issue.