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 recordsUsing on UI with ng-repeater50 results per pageI 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?
When to use pagination from database with ajax request
database;query;pagination