>Hi everyone,
>
>I have inherited a system that uses Filters, I have always stayed away from filters because they were always slow. Well now my users are compaining about the system being slow when I update the grid (another thing I am not to fond of).
>
>My question is what is my alternative to filters to let the users see only a subset of the data but will provide the some speed when switching subsets?
>
>I have not used views but that is a select of the data so it should not be any faster. I could build a table and set a relation to show the data but then how would I let the users sort the data in the grid?
>
>Some background info:
>
>35,000 records
>set filter to fielda = a and fieldb = b and fieldc = c
>indexes on major fields
>
>for the filter I have an index like this:
>index on fielda+fieldb+fieldc tag tag1
>
>Thanks for your suggestions
>
>Jeff Whitaker

I'm pleased to add something new to this particular thread. Actually, the fastest way to get the comparably small recordset (let say 100 records) is SEEK/SKIP/INSERT. At the same time you may get the most flexible grid on output end. One more thing that will even highlight the speed. It's enough to retrieve primary key field only.