Database performance tuning
refers to a set of activities and procedures designed to reduce the response time of the database system _that is, to ensure that an end-user query is processed by the DBMS in the minimum amount of time.
- Good database performance starts with good database design.
PERFORMANCE TUNING: CLIENT AND SERVER
In general, database performance-tuning activities can be divided into those taking place on the client side and those taking place on the server side.
• On the client side, the objective is to generate a SQL query that returns the correct
answer in the least amount of time, using the minimum amount of resources at the
server end. The activities required to achieve that goal are commonly referred to as
SQL performance tuning.
• On the server side, the DBMS environment must be properly configured to respond
to clients’ requests in the fastest way possible, while making optimum use of
existing resources. The activities required to achieve that goal are commonly
referred to as DBMS performance tuning.
DBMS ARCHITECTURE
The architecture of a DBMS is represented by the processes and structures (in memory and in permanent storage) used to manage a database. Such processes collaborate with one another to perform specific functions. Figure bellow illustrates the basic DBMS architecture.
المادة المعروضة اعلاه هي مدخل الى المحاضرة المرفوعة بواسطة استاذ(ة) المادة . وقد تبدو لك غير متكاملة . حيث يضع استاذ المادة في بعض الاحيان فقط الجزء الاول من المحاضرة من اجل الاطلاع على ما ستقوم بتحميله لاحقا . في نظام التعليم الالكتروني نوفر هذه الخدمة لكي نبقيك على اطلاع حول محتوى الملف الذي ستقوم بتحميله .
|