Let's say I have a very large (millions of records) DB of cars but one of the column (colors) has only a couple of different choices (red, green, blue, black, white).
When I'm binding the DB to the GridView (using pagination because I can't load the whole table at once and data virtualization is performing poorly on this amount of data) and trying to filter by color every time I open the filter editor I'm sending a query to my DB asking for Top 1000 Distinct colors which is really slow.
Now my question is, can I have a predefined list of available colors to use for my Filter Editor? Just create a List<String> and feed it to the editor?
Thank you.