Informix Shared Memory and perf probs

From: Holger Banko <banko_at_gmx.de>
Date: Wed, 03 Mar 1999 14:50:10 +0100

Hello,

we have many performance problems in combination with Inormix Dynamic Server
and DEC OSF4.0x.

If we are setting the SHMVIRTSIZE paramter in informix/etc/onconfig to a
value of 20% from the memory of the machine (Alphaserver 800, 256 MB Ram)
runs after a few db-accesses very very slow. If we wait 20 minutes and doing
nothing on the machine, it will run fast again - until there are a few
db-accesses!

The Problems grows if we are setting the SHMVIRTSIZE paramter higher. By
setting the SHMVIRTSIZE to just 16MB the performance is very good (the db is
small and there are just 15 users) 8-] ?

We tried to reproduce this on two other machines and had the same problem
(Alpha Server 4000 - 512 MB) !

We asked the DEC support and Bytec (Germans biggest Informix Distributor)
but both donīt have a solution for this problem ....

Any ideas ?

Bye
Holger

mail: banko_at_gmx.de
Received on Wed Mar 03 1999 - 13:45:27 NZDT

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:39 NZDT