3 ms·
That depends upon the definition of "entire table". Most situations have already pre-filtered data to some reasonably small quantities -- e.g. category, genre,
by corresation 14y ago
That depends upon the definition of "entire table". Most situations have already pre-filtered data to some reasonably small quantities -- e.g. category, genre, exchange date, etc. Yes, caching and working on that set is almost always the superior option.
- benologist 14y agoI think this is where we're branching apart - I see pagination as part of that pre-filtering against a larger dataset. Having a dataset your web server can crunch and cache is just one use case.