>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.
Edward Pikman
Independent Consultant