How to limit the resultset when using pagination?

[eluser]jegbagus[/eluser]
kbkb, add LIMIT query at your sql.
example :

Code:

select * from yourtable limit 10,5

10 will be the number generated by CI pagination library, and 5 number of row every page.

best regard