selection set and @td

[GCC Consulting]

From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com] On Behalf Of dave kasper
Sent: Thursday, January 17, 2008 12:12 PM
To: filepro-list at lists.celestial.com
Subject: selection set and @td

im trying to build a demand index with selection set of
field eq @td  or field eq @t4 . my field is (10,mdyy/) but doesn't work. I'm trying to bypass the sort selection scan of all records and just build the index on the records needed to speed up the several reports that need this data, but it never works i run this report everyday and need it to select just today's records only.  Any ideas? im on a unix system and running v 5.6

Try this format:
Group   Field  Heading                 Rel    Value
────────────────────────────────────────────────────────────────────────────────

        ◄  3  ◄ s_date                  eqf◄   @td◄
        ◄     ◄                            ◄                                 ◄
        ◄     ◄                            ◄                                 ◄
        ◄     ◄                            ◄                                 ◄
        ◄     ◄                            ◄                                 ◄

This should work.

You might consider, if you already have an index using your date field adding -j to the command line.  This should speed up record selection as fp will use this index to get to the record.

You could also use a sort/selection process -v if you have and index with the first parameter this date field.  You would use a lookup - in the processing on @t4 etc.

Contact me off list if you would like a sample of this type of processing.


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net