Coding Tips

It is a common requirement to have pagination in Web applications. The easy way is to query all the records and then apply pagination logic to the data in memory. But this approach won’t work with tables which contains huge data sets.
The best approach is to do the pagination at database level using SQL. Database [...]