Re: Online 7.10 performance on Stratus and others

zondag@xs4all.nl (Jan-Evert Zondag) wrote: >My employer has recently installed Informix 7.10 on a fault tolerant Stratus >R15 dual processor with FTX 2.3, for testing purposes. We are suffering from a >severe performance degradation when more than one query/update thread accesses > the database simultaneously. Informix and Stratus experts are working on it. >Similar tests by Informix on a HP machine do not show this degradation. One thing you might look at is the PDQPRIORITY and MAXPDQPRIORITY paramteres in your config file. If both are set to 100, then a query will use 100% of the system's resources to complete that query. A better alternative is to set PDQPRIORITY to "off". Then control the actual usage on a job by job bases using the environmental variable PDQPRIORITY. Before I did this, I had the same problem with 7.1 on an AT&T 3555 server. Now, it smokes! Something else to think about is 7.1 is heavily multithreaded. A dual processor system does not really take advantage of this. More cpus greatly improve performance. Ed Kelley, Senior Specialist AT&T Network Systems - CIO Email: ekelley@mindspring.com or ekelley@attmail.att.com or ekelley@msn.com or ekelley@ichange.com WEB page: http://www.mindspring.com/~ekelley/html/ekelley.htm