INFORMIX is one of the most widely used large databases in the domestic financial industry, and its configuration parameters have an important impact on system performance. This paper focuses on the performance problems of the data warehouse system of a commercial bank in a certain province. By monitoring the performance of INFORMIX, the system bottleneck is determined, and on this basis, optimization measures are given in terms of virtual processors, shared memory, query optimizer, and data extraction. Practice has shown that the system performance has been significantly improved through tuning. The methods of analyzing and solving problems proposed in this paper have a certain degree of universality, and the optimization strategies adopted are of reference significance to similar systems. Keywords: INFORMIX database; performance monitoring; system optimization
You Might Like
Recommended ContentMore
Open source project More
Popular Components
Searched by Users
Just Take a LookMore
Trending Downloads
Trending ArticlesMore