Getting a subset of items: Is it better to user PagerDefault and limit, or get'em'all and array_splice? I want to pull some number of nodes out of the database for rendering and display.  There are several ways to do this, two of which would be:


do a db_select(...)-&gt;extend('PagerDefault'); and add a -&gt;limit()
clause to specify the number of items to be returned.
do the db_select() without the PagerDefault, and use
array_slice to get the desired number of items.


Any advice on the relative advantages of these, especially from a performance perspective?  I've done a few informal tests that suggest about a 100% penalty for using PagerDefault, but I wouldn't want to claim these are definitive.  Any recommendations?
Use range() instead:

db_select(...)-&gt;range(0, 10);