Re: Informix and PDQ

}>From ilist@rmy.emory.edu Fri Apr 18 12:26:15 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 MAA29335; Fri, 18 Apr 1997 12:26:12 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id LAA12873 for informix-list-out; Fri, 18 Apr 1997 11:40:01 -0400 (EDT) }>From: Dirk Fromhein <Dirk.Fromhein@watershed.com> }>Message-Id: <3356D199.266F@watershed.com> }>Subject: Re: Informix and PDQ }>Date: Fri, 18 Apr 1997 06:42:49 +0500 }>Reply-To: Dirk Fromhein <Dirk.Fromhein@watershed.com> }>Organization: Watershed Technologies, Inc. }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.36811> }> }>Jeff Craig wrote: }>[munch] }>> 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. }>> }> }>I must be missing something... we have a DSS product and we just do a }>SET PDQPRIORITY x; }>in the SQL code we generate. For create table, drop table, and select }>from single entity SQL we set it to 0, for "real" statements we set it }>to a user configurable setting. }> }>Now if we could only get the real word from Informix on what PDQ really }>means :-) }> }>I assumed that since for most of our queries we see almost no speed }>increase from a setting of 5 to 40, we could run 20 queries at 5. Nope, }>no show. Informix recomends sending one query at a time throught the }>engine at PDQ 100. It seems that multiple queries really freak the }>engine out (8.1x). }> }>We currently use JDBC drivers from weblogic (http://www.weblogic.com) to }>make the connection, but we have used Visigenics and Intersolv ODBC }>drivers as well as using the ESQL Runtime libs (I-Net, now C-Net). }> }>Cheers, }>Dirk Fromhein }>df@watershed.com }>http://www.watershed.com }> I would be interested in what DSS "product" you have. Most DSS products don't require the user to "code SQL", since they generate it automatically based on the point-and-click data choices that the user makes. This is the case with BusinessObjects, which generates SQL based on table and column (actually, Universe) selections. In products of these type, you don't have the opportunity to influence the SQL that is generated, i.e., you cannot add the SET PDQPRIORITY statement. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------