Hello there ,

Actually set filter is supposed to use optimization of rushmore technology and it should not be slow.
Do check your settings of set optimize and set it on if it is off.

U can also use a cursor created by SQL commands to increase your speed of retreivals.
Hope this helps.

Ajay Sanghani
WinSmart Solutions
Building Software Better and Faster
http://www.winsmart.com
email : ajay@winsmart.com

>Hello,
>
>I'm using a form to browse and update a table with the
>fields: organisation, customer, ...
>
>On the form only records of one organisation should be
>displayed. The user is able to select the organisation
>with a command button. I have set a filter like this:
>organisation = '001'
>
>I have also an index on organisation to optimize the filter.
>But it is still very slow:
>
>e.g. Organisation '001' 150000 records
> Organisation '002' 250 records
>
>It seems that in the case of organisation '002' all records
>were read -> takes 70 seconds to move from the first to the
>last record.
>
>Without a filter it is quite fast.
>
>Any suggestions?
>
>Thanks in advance.
>
>Andreas