pdf

Tuning INFORMIX under high load environment

  • 2013-09-22
  • 129.06KB
  • Points it Requires : 2

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

unfold

You Might Like

Uploader
PKelect
 

Recommended ContentMore

Popular Components

Just Take a LookMore

EEWorld
subscription
account

EEWorld
service
account

Automotive
development
circle

About Us Customer Service Contact Information Datasheet Sitemap LatestNews


Room 1530, 15th Floor, Building B, No.18 Zhongguancun Street, Haidian District, Beijing, Postal Code: 100190 China Telephone: 008610 8235 0740

Copyright © 2005-2024 EEWORLD.com.cn, Inc. All rights reserved 京ICP证060456号 京ICP备10001474号-1 电信业务审批[2006]字第258号函 京公网安备 11010802033920号
×