Cache Associativity on the Performance of Database Systems:Problems, and Optimization Strategies
Kaiqi Feng · 2005
In this paper,we studied the impact of cache associativity on the performance of database systems,and pre- sented a new optimization technique,which can reduce the cache conflict miss during the data access significantly. This technique is very simple,and requires only a trivial modification on current database systems. We have already implemented this technique in Postgres, MySQL, two famous open-source database systems, and also CoreBase, a database system developed by ourselves. Experiment results have shown that,the query performance of all above sys- tems were improved greatly.