Performance Tuning
The main goal of performance tuning is to minimize the response time of the given queries and to make the best use out of your server's resources by minimizing the network traffic, disk I/O and CPU time. All factors must operate at optimum level with minimum bottlenecks. This goal can be achieved only by understanding the logical and physical structure of your data, the applications used on your server and how the many conflicting uses of your database may impact database performance. A good database performance starts with good database design. The most appropriate way to avoid performance problems is to ensure that performance issues are part of your ongoing development activities. Most significant performance improvements are realized through careful design at the beginning of the database development cycle. For the most effectively optimize performance, you must identify the areas that will yield the largest performance increment over the widest variety of situations and focus your analysis on those areas. Performance Tuning between the Client and Server Client side:It generates SQL query that returns correct answer in least amount of time. It does this by using minimum amount of resources at server. Server side:DBMS environment is configured to respond to client's requests as quickly as possible. This is due to the optimum use of existing resources.
Summary
The main goal of performance tuning is to minimize the response time of the given queries and to make the best use out of your server's resources by minimizing the network traffic, disk I/O and CPU time. All factors must operate at optimum level with minimum bottlenecks. This goal can be achieved only by understanding the logical and physical structure of your data, the applications used on your server and how the many conflicting uses of your database may impact database performance. A good database performance starts with good database design. The most appropriate way to avoid performance problems is to ensure that performance issues are part of your ongoing development activities. Most significant performance improvements are realized through careful design at the beginning of the database development cycle. For the most effectively optimize performance, you must identify the areas that will yield the largest performance increment over the widest variety of situations and focus your analysis on those areas. Performance Tuning between the Client and Server Client side:It generates SQL query that returns correct answer in least amount of time. It does this by using minimum amount of resources at server. Server side:DBMS environment is configured to respond to client's requests as quickly as possible. This is due to the optimum use of existing resources.
Things to Remember
- The main goal of performance tuning is to minimize the response time of the given queries and to make the best use out of your server's resources by minimizing the network traffic, disk I/O and CPU time.
- This goal can be achieved only by understanding the logical and physical structure of your data, the applications used on your server and how the many conflicting uses of your database may impact database performance.
- The most appropriate way to avoid performance problems is to ensure that performance issues are part of your ongoing development activities.
- Most significant performance improvements are realized through careful design at the beginning of the database development cycle. For the most effectively optimize performance, you must identify the areas that will yield the largest performance increment over the widest variety of situations and focus your analysis on those areas.
MCQs
No MCQs found.
Subjective Questions
No subjective questions found.
Videos
No videos found.
Performance Tuning
Performance Tuning
The main goal of performance tuning is to minimize the response time of the given queries and to make the best use out of your server's resources by minimizing the network traffic, disk I/O and CPU time. All factors must operate at optimum level with minimum bottlenecks. This goal can be achieved only by understanding the logical and physical structure of your data, the applications used on your server and how the many conflicting uses of your database may impact database performance. A good database performance starts with good database design.
The most appropriate way to avoid performance problems is to ensure that performance issues are part of your ongoing development activities. Most significant performance improvements are realized through careful design at the beginning of the database development cycle. For the most effectively optimize performance, you must identify the areas that will yield the largest performance increment over the widest variety of situations and focus your analysis on those areas.
Performance Tuning between the Client and Server
Client side:It generates SQL query that returns correct answer in the least amount of time. It does this by using the minimum amount of resources at the server.
Server side:DBMS environment is configured to respond to client's requests as quickly as possible. This is due to the optimum use of existing resources.
References:
- H.F.Korth and A. Silberschatz,"Database system concepts",McGraw Hill,2010
- A.K.Majumdar and p, Bhatt acharya,"Database Management Systems",Tata McGraw Hill,India,2004
- F.Korth, Henry. Database System Concepts. 6th edition.
Lesson
Query Processing and Optimization
Subject
Computer Engineering
Grade
Engineering
Recent Notes
No recent notes.
Related Notes
No related notes.