Which is the best method to do pagination so that load on server is minimum
Hi, I have done a bit of research on pagination and from what i have read there are 2 contradictory solutions of doing it Load a small set of data from the database each time a user clicks next Problem - Suppose there are a million rows that meet any WHERE conditions. That means a million rows are retrieved, stored, filesorted, t...