>>
>>Usually you handle this kind of thing with parameterized views? Is that possible in this scenario.
>
>Yes but I do not understand how this would be any faster because you would have to do a requey() everytime you change the parameter right?

Jeff,

Filters and grids don't like each other. The gird, when populating itself is ignorant of Rushmore and so the filter is not optimized. A parameterized view will be very fast, especially when the filter reduces the total number of records to a reasonable set.