Re: Query Performance

[PaulMmn <PaulMmn@xxxxxxxxxxxxx>]

>    Please advivse how to  best minimize the performance degradation of
>interactive queries on  QINTER .  V3R7 on my machine.  I intend to conduct
>a Query class  this week and need to solve this issue if i can.  I have
>essential  operations working 24/7 so there is no downtime to take
>advantage  of.
>"John P. Walsh" <john_walsh@icdc.com>

Best way is to make all queries run in batch.  (:  If your machine has the
horsepower, the queries will be done almost as fast as interactive.  Your
mileage may vary.

Education is the next best way.

Teach your amateurs to NOT combine more than 2 or 3 files at once!  I like
to encourage use of intermediate files to hold partial results, that are
then merged together to create the final answer.  Although your users will
run more queries, they will (hopefully) take less total time to run, since
they're not joining that 4th file that requires Query to build a huge
intermediate file.

Our resident expert recommends:

        Intermediate files

        Select just the records you need to those intermediate files

        DO NOT SORT until you have winnowed your records down to just the
ones you need


--Paul E Musselman
PaulMmn@ix.netcom.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---