>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
Usually you handle this kind of thing with parameterized views? Is that possible in this scenario.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only