Kbase P99135: Why does my application run slower when more data is added to the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/21/2004 |
|
Status: Unverified
GOAL:
Why does my application run slower when more data is added to the database?
FIX:
In many situations where the query doesn't change yet over time the response time of the query increases this is due to a lack of a well formed index which matches the query.
Adding a new index to the table which the query can use to reduce the result set of the records will significantly improve the response time of the query.