Hi there,

I've been unable get the Query Plan Viewer (w3sqlqpv.exe) running with
PSQL9.1. I have configured the ODBC connections as per PSQL8.6
(QryPlan=1, QryPlanOutput=FILENAME) but have not had any luck. I
haven't been able to find out anything on Pervasive's website about
how to configure it (or even whether it works with v9).

Would anybody have any information on whether it still works with v9
and, if so, how to set it up to capture SQL execution plans.

many thanks in advance

Andrew

It does still work. Execute these statements from your SQL window:

SET QRYPLAN=on;
SET QRYPLANOUTPUT='C:\PVSW\query.qpf';

Then, your queries will be captured. Set QryPlan to OFF to shut off
the feature.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2007 ***


aeshepherd (AT) yahoo (DOT) com wrote: