PDQ

Is PDQ an option that has to be turned on? Is it an option that would be recommended for an OLTP application (or is it DSS specific functionality)? I would like to ensure optimum performance from my production server and am not sure if PDQ is appropriate in an OLTP environment. SC

Stephen F. Cawley <sfcawley@interaccess.com> wrote in message news:7uafc7$ofr$1@news.xmission.com... > > Is PDQ an option that has to be turned on? No. You must set PDQ params as you want - and you can use this feature Is it an option that would be > recommended for an OLTP application (or is it DSS specific functionality) This depends on your application. PDQ allows high degree of parallelism, but you must test enough before using this in OLTP. Also consider your hardware resourses. But such things, for example, index builds can be used in OLTP with no problems. ? > > I would like to ensure optimum performance from my production server and > am not sure if PDQ is appropriate in an OLTP environment. Correct. PDQ can sometimes decrease performance in OLTP. I want to say _incorrectly_tuned_ PDQ. ----------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > SC > > >