[SQLObject] limit/offset question?

[inhahe <in...@gm...>]

Hi, i have a question about limit/offset.  i read something that says if
you're doing something like pages of results with next/previous buttons, you
should do the query once and then cache the results for a certain period of
time, but then my friend says you can do limit(x,y) where, i guess, one
variable is the starting point and the other is the number of records.  then
i found out about the "offset" keyword on the web, so i guess the proper way
is to use limit and offset.  either way, this seems more efficient than
caching the whole query--is it?  and how do i do this in sqlobject?  or
should i just store a query and use slicing on it?  or just do the same
query each time and use slicing on it since sqlobject caches certain things
anyway?  thanks.