I'm currently writing a wrapper for the data store to interface with ruby on rails and I was pondering whether to dynamically switch between local and remote sorting depending on the number of rows required. Specifically for when your not loading the entire data set (i.e. when your using some sort of pagination).
Lets say we've got 20,000 rows in our table and we're only looking at sets of 100, we'd setup using remote sort, remote filtering so everything is done server side.
If we've got 200 rows in our table, there's probably no need to hit the server for sorting and filtering so we might as well load everything into the data store and do everything client side.
So my question is, what do you guys reckon the sweet spot is for the number of rows for when you should switch to server side filtering?
Additionally do you think it's a good idea?