jebaird.com

Pagination is one of the simple features of a site if used right can be a great feature.  For something very simple it seems to be a resource hog.  For a while I have been looking for a way to paganate with out issuing two database queries.  After some quick searching I could not find what I was looking for, so I came up a method that uses a one query + a sub-query.

Quick Review

The method that I have seen the most, looks like some like this.