Is there a "rule of thumb" to when it is right to take partial result from a table, rather than the whole table?
Consider my current dilemma:
- SQL view that has total of ~1200 items, the view is not so complex only joining from several tables.
- Query for some property, total results ~600 records
- Using on UI with ng-repeater
- 50 results per page
I would like to say that as a 'rule of thumb' if it is less than 1000 records I will bring the whole table. (Unless the view is really complex and takes more than 1 second to populate).
Otherwise I will bring the first 2 pages (100 results) and then 50 per page switch.
Would you agree?