Best Way Browse Results N per page
Posted on 2011-03-11
Which is the best solution to select and browse results N per page?
Let us suppose I have a database with 100,000 records and I want to browse them 10 per page; should I select for each page all 100,000 records and then show them using startrow and maxrows?
Is it possible to select, for each page, only 10 of them using something like the MySQL command "LIMIT" ?
I use Coldfusion + SQL Server