Database tuning

Under Tuning refers to the fine-tuning of parameters of a database installation or modifiable properties of a database application with the goal of improving performance.

A Tuning the database installation is therefore possible, and often necessary, because most offer database management systems (DBMS ) is a huge, heavy gear or range of installation and operation options. Thus it can be set, for example, which parts of which database tables are physically stored in which storage areas. Furthermore, buffer sizes, the behavior of the database regarding not yet shared data changes ( see transaction ), index types and many are influenced more specifically. It is obvious that such attitudes affect performance.

A database tuning is usually performed by highly qualified specialists and is a very cost -intensive exercise with predictable results difficult. Often comparable improvements with hardware enhancements can be achieved at lower cost. Therefore, the tuning is often limited to a few simple measures or on high- end applications.

Alternatively, it is possible to optimize not database installation but the data model. Typical of this is the denormalization. The structures, notwithstanding the changes of the logical ideal structure so that the real need SQL access have access to less database tables and therefore are much faster. By optimizing the data structures are usually much larger performance improvements reach, but with the disadvantage that it often requires a change of the completed programs. By the use of the data structure of Views but at the application level in many cases, can be maintained.

Possibilities of tuning access mechanisms

  • Clustering
  • Hashing
  • Indexing
  • Scanning
  • Database Theory
786365
de