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 db which becomes an issue if there are even thousands of records. I can add some helper methods like has_members or count_members() to implement this by hand but there is still risk that client code can just naively access coll.members and got performance hit. Is there a way to use a COUNT(*) query in context like these? ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
