On Sat, May 16, 2009 at 03:52:28PM -0400, inhahe wrote: > 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.
In SQLObject, MyTable.select() doesn't return a list of rows - the call returns an instance of SelectResult class which maps slicing to limit/offset. This is how you should do it: for row in MyTable.select(query)[offset:offset+limit]: process(row) Oleg. -- Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ 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