Re: Informix and PDQ

}>From ilist@rmy.emory.edu Fri Apr 4 07:29:52 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id HAA17963; Fri, 4 Apr 1997 07:29:49 -0700 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id HAA01654 for informix-list-out; Fri, 4 Apr 1997 07:10:01 -0500 (EST) }>From: Nils.Myklebust@idg.no (Nils Myklebust) }>Message-Id: <3344eacc.8235011@gate.idg.no> }>Subject: Re: Informix and PDQ }>Date: Fri, 04 Apr 1997 11:54:05 GMT }>Reply-To: Nils.Myklebust@idg.no }>Organization: NM Data AS }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.36169> }> }>settler@hobbes.dbintellect.com (Jeff Craig) wrote: }> }>:}>BTW, just for the record, PDQPRIORITY needs to be set at the SQL level, }>:}>not at the engine level. I've seen things get quite scary when }>:}>PDQPRIORITY is set in the ONCONFIG file. }>:}> }>:}>Anyone else out there have tidbits? reminders? experiences? warnings? }>:}> }>:}>John Carlson }>:}>Informix DBA }>:}>WH Smith Inc. }>:}>Any of my ideas are mine alone and not necessarily those of my company. }> }>:It would be nice if third-party products, such as BusinessObjects, }>:allowed you to pass through PDQPRIORITY, but they do not, nor does }>:I-Connect. Therefore, you may be forced to set it globally in order }>:to gain its benefits. Note that as of Informix 7.2x, the PDQPRIORITY }>:parameter in onconfig is obsolete, so global setting is accomplished }>:via informix.rc file. Also, if you are running Informix 7.2x on }>:Silicon Graphics IRIX 6.2, and you are running NUMCPUVPs > 1, and }>:PDQPRIORITY is > 1, you will get incorrect results if the SQL }>:contains count(distinct columnname). }> }>If you do not use I-Connect, but a real ODBC driver instead, you can }>have that driver set PDQPRIORITY on a session level basis. It can be }>set automatically by the driver each time you connect to the database. }>I think this can even be done based on the application you are running }>(like access rights can), but I haven't checked the documentation for }>that. }> }> }>Nils.Myklebust@idg.no }>NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway }>My opinions are those of my company }>The Informix FAQ is at http://www.iiug.org }> Very true statement. I would prefer to use OpenLink, as it is incredibly configurable. Alas, BusinessObjects running on a Windows 95 workstation and connecting to Informix 7.x can only communicate via I-CONNECT as of late last year. The Visigenic ODBC driver for Windows 95-Informix 7 was due for general availability as of January, 1997, but I am not sure where it's at. Due to my project timeline, I had no choice but to use I-CONNECT and set PDQPRIORITY globally. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------