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