Kbase P118606: Universal factors that effect the performance of a dtabase application?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/04/2011 |
|
Status: Verified
GOAL:
What are some of the universal factors that effect the performance of a database application?
GOAL:
What could make an application run fast on a machine and slow on an other?
GOAL:
Why does an application have a good performance on one computer and a poor performance on another?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Application performance problems can be caused and mitigated by of the following factors:
1. Network topology and throughput
2. Server hardware configuration (for database and web servers)
3. Front-end application code developed.
4. Middle-tier components.
5. Database code and startup parameters.
6. Server or other database configuration settings.
7. Logical and physical database design.
8. Operating system settings.
9. Client hardware capabilities including memory, graphics, storage, networking, etc.
10. Overall application architecture.
11. Any combination of the items above.
Application or database performance tuning is not a simple exercise and requires the efforts of highly qualified database and application engineers. Contact Progress Professional Services to explore how you can get a high quality professional performance tuning for your database or application.