Re: [SQLObject] RelatedJoin efficiency

2006-04-20 Thread Luke Opperman
You could use a SQLRelatedJoin, and then do: coll.members.count() - Luke Quoting Oleg Broytmann <[EMAIL PROTECTED]>: On Thu, Apr 20, 2006 at 03:54:18PM +0300, Max Ischenko wrote: Is there a way to use a COUNT(*) query in context like these? There is no currently. Oleg. -- Oleg Bro

Re: [SQLObject] RelatedJoin efficiency

2006-04-20 Thread Oleg Broytmann
On Thu, Apr 20, 2006 at 03:54:18PM +0300, Max Ischenko wrote: > Is there a way to use a COUNT(*) query in context like these? There is no currently. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just GOSUB withou

[SQLObject] RelatedJoin efficiency

2006-04-20 Thread Max Ischenko
Hi, I have two tables that are related via intermediate tables (expressed with RelatedJoin in SQLObject): class Collection(SQLObject): members = RelatedJoin(...) when I evaluating expr like len(coll.members) or "if not coll.members" it seems to actually fetch (and discard) some data from d