When it comes to pagination, the simplest method that comes to the mind is the skip-limit, but it is not always the best solution!