Re: Sorting

Zak - to give you an example, I have a web application where users can
search 2 million
records. The have 10 different search fields, and can enter any combination.
I was able to learn from the users what their "normal method" of searching
was, and built 8 logicals based on "most used" searches. (These are property
record searches by names or addresses or other stuff). An RPGSQL prepares
and executes the select, and orders the fields in an order matching the
logicals. So instead of 2 minute searches we get 2 second searches on a tiny
S10 server. If you need a sample of the rpgsql send me an offline note.
If you don't build the logicals, you will always have long selection time.
hth
jim
----- Original Message -----
From: "Metz, Zak" <Zak_Metz@xxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, April 30, 2003 3:02 PM
Subject: RE: Sorting


> The number and length of the key fields varies wildly, but at times
> exceeds what FMTDTA can handle. The problem I have with your suggestion
> is that no LF exists so I would have to first write DDS to create it,
> compile it, then RGZPFM, and finally blow away the LF. Again, the
> sorting is only known at run-time.
>
> Thanks, though!
>
> > -----Original Message-----
> > From: DeLong, Eric
>
> > How many key fields?
> >
> > Is creating a new logical file out of the question?  If the
> > intent to have
> > PF in a specific record order, why not RGZPFM with the KEYFILE parm
> > referring to your logical....
> NOTICE: This E-mail may contain confidential information. If you are not
> the addressee or the intended recipient please do not read this E-mail
> and please immediately delete this e-mail message and any attachments
> from your workstation or network mail system. If you are the addressee
> or the intended recipient and you save or print a copy of this E-mail,
> please place it in an appropriate file, depending on whether
> confidential information is contained in the message.
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>