Question

A web page displays 10 items per page and has pagination enabled. What would be the recommended way to enable efficient paging?

Answer 1

This seems to be quite simple mathematics but somehow tricky which your brain cannot think of.

I am planning to implement pagination and will require calculating the item offset to use in restricting my result.

I am having difficulties calculating what index the first item of the page must have. Offset = page * itemsperpage + 1.  

Answer 2

Correct Answer is:    Use Spatial Cache