How to efficiently paginate database results

in PHP added by quipo, on 1/7/2007 PEAR advanced tutorials database pager

PEAR::Pager was written with the purpose of paginating arrays. While you can fetch all the records from a database, store them into an array and pass it to Pager, this method isn't particularly efficient. If you have large resultsets, it isn't efficient at all. There's a better solution: please welcome Pager_Wrapper.