![]() ![]() These topics discuss the performance considerations that are involved when you use table fragmentation. Proper fragmentation of high-use tables can significantly reduce I/O contention. Fragmentation guidelines One of the most frequent causes of poor performance in relational database systems is contention for data that resides on a single I/O device.Locking The database server uses locks, which can affect concurrency and performance.Some performance issues are associated with indexes. Indexes and index performance considerations Informix® provides several types of indexes.Boosted Partition Free Space Caches (PFSC).Table performance considerations Some performance issues are associated with unfragmented tables and table fragments.Effect of configuration on I/O activity The configuration of your database server affects I/O activity.Effect of configuration on memory utilization The combination of operating-system and Informix® configuration parameters can affect memory utilization. ![]() You can change the settings of the Informix® configuration parameters that directly affect CPU utilization, and you can adjust the settings for different types of workloads.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |