>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement