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.
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
