On Tue, Jun 22, 2010 at 11:20:39AM +0200, Imre Horvath wrote:
> Is it possible to select only a few columns from a table?
No, but you can lazily selects columns using lazyColumns=True; with this
SQLObject doesn't initially draw any column, only id's; but when you touch a
row and ask for a column SQLObject executes a specific one-row one-column
SELECT query. If you are going to touch a million rows this lead to at least
few millions queries; perhaps it'd be faster to select all columns at once,
but YMMV.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
