Re: SQL Troubles

["Elena Morozova" <lena@xxxxxxxx>]

Yes, I tried to add "order by"  or "group by".  It really makes the
performance much worse.
But  it seems to me that "distinct"  sorts  selected records - though I'm
not quite sure.  I tried it on our files - the result is sorted.  So if you
need only sorted list of invoice numbers  - may be you don't need to add in
the sort criteria ?

----- Original Message -----
From: "John Hall" <jhall@hillmgt.com>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, March 05, 2001 5:03 PM
Subject: Re: SQL Troubles


> Yes that works - but when I add in the sort criteria the performance
> just isn't there.  Split up into separate statements the record
> selection is pretty fast.  With a combined statement it takes about 20
> seconds to return the result.  So what I need to do is have it select
> the records from APDIST, Find the matching records from APINVOICV and
> then perform the ORDER BY Clause.  The last two steps should take
> minimal processing time since there are usually less then 10 invoices
> and the file is keyed on VOUCHER.
>
> John
>

+---
| 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
+---