Dave's right, if you can look for a specific value (or values with "x""y""z") you'll get significantly faster speed than with with BY.EXP. You can then use a LOCATE(..) in BASIC to figure out which rows are to be included on the report.
On Tue, Aug 27, 2013 at 11:58 AM, Lunt, Bruce <bl...@shaklee.com> wrote: > Each record has 2-5 multi-values that are date periods. I am looking for > the most recent 3 periods. There are over a million records so the BY-EXP > gives me 3 million values to process. I thought about writing a work file > with the values in a separate record but the size seems like it would take > forever to do and then I would still need to create the report from the > work file's 3 million records. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis > Sent: Tuesday, August 27, 2013 10:52 AM > To: U2 Users List > Subject: Re: [U2] UDT 7.1 Indexing question > > It really depends on the percentage of records that contain the value you > are looking for - multivalued or not > > I think if you include a criteria like: > > WITH mv_indexed_field = "value" > > it will be faster than without the index. > > However, if most of the records in the file have that value it won't make > much difference. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce > Sent: Tuesday, August 27, 2013 1:46 PM > To: U2 Users List > Subject: Re: [U2] UDT 7.1 Indexing question > > That's what I was afraid of. I have a large file and I was looking for > some way to speed up a report that I am creating with Uniquery. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Tuesday, August 27, 2013 10:43 AM > To: U2 Users List > Subject: Re: [U2] UDT 7.1 Indexing question > > My guess is that it shouldn't matter. Each multivalue in a list gets a > separate index entry. > > > On Tue, Aug 27, 2013 at 10:46 AM, Lunt, Bruce <bl...@shaklee.com> wrote: > > > Hi All, > > > > Will indexing a field that I retrieve with BY-EXP be faster than an > > un-indexed field? > > > > Thanks, > > Bruce > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ________________________________ > > > Dave Davis > Team Lead, Research & Development > > P: 614-875-4910 x108 > F: 614-875-4088 > E: dda...@harriscomputer.com > [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg > ] > > [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]< > http://www.harriscomputer.com/> > 6110 Enterprise Parkway > Grove City, OH > 43123 > www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com> > > This message is intended exclusively for the individual or entity to which > it is addressed. This communication may contain information that is > proprietary, privileged or confidential or otherwise legally exempt from > disclosure. If you are not the named addressee, you are not authorized to > read, print, retain, copy or disseminate this message or any part of it. If > you have received this message in error, please notify the sender > immediately by e-mail and delete all copies of the message. > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users