RE: OPTCOMPIND

Posted in 2005

Dirk Moolman — Wed, 17 Aug 2005 11:04:34 +0200 — source: Usenet: comp.databases.informix

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Colin Dawson Sent: 17 August 2005 09:57 AM To: informix-list@iiug.org Subject: OPTCOMPIND >Apologies if this has been discussed before..... > >I'm interested in people's opinions on what they have set this parameter to >for OLTP systems and why they used that setting. I'm not interested in what >the parameter means, I know that, I can RTFM as well as anybody. > >FYI: I am using 0 on one system and 2 on another and there doesn't seem to >be any noticable degradation in response times, query times are very >similar My systems are set to 2, after testing it. When we upgraded a while back, I tried both 0 and 2, and 0 proved to be very slow on my specific system (running on 7.31 FD3) sending to informix-list