>Sergey
>
>
>
>On the subject of filters an example of how to dramatically speed them up.
>
>Lets assume we have 2 tables
>
>Joblist contains a list of jobnos and datetime created (approx 500) records
>Jobdetails contains jobdetails (with jobno and datetime created) approx 50,000 records.
>
>If we look at example 1
>
>select jobdetails
>SET FILTER TO created=joblistcreated
>
>This can be very slow especially across a network.
>
>
>Now look at example 2
>
>select jobdetails
>set order to tag created
>seek(joblist.created)
>SET FILTER TO created=joblistcreated
>
>The improvement in speed is dramatic. Filter setting times on one of my large systems have dropped from 10-15 seconds to almost instantaneous.
>
>Colin Northway
In this case you can use SET KEY instead of SET FILTER for better performance.
--sb--