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
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