Hi Jeff.

Dan is right: A parameterized view will be MUCH faster. Try it, you'll see.

>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