Thanks! Sorry, my email filter moved this into a hidden folder. I'll take a look :) Here's hoping -S
-----Original Message----- From: Simon Cross [mailto:hodges...@gmail.com] Sent: Thursday, July 21, 2011 1:32 AM To: Simon Laalo Cc: sqlobject-discuss@lists.sourceforge.net Subject: Re: [SQLObject] eagerly fetching joined objects Hi On Thu, Jul 21, 2011 at 2:07 AM, Simon Laalo <sla...@resiliencesoftware.com> wrote: > I'm currently trying to improve my DB performance by reducing the number of > queries > and associated overhead while grabbing some SQLObjects from the DB. I would > like > to have SQLObject fully populate the object graph for the objects I'm using > since all > joined objects will be read every time this object is loaded. I encountered a similar need in one of my own projects and wrote a caching version of RelatedJoin that you could probably take ideas from for a caching version of MultipleJoin / ForeignKey. You can find the code at http://sutekh.svn.sourceforge.net/viewvc/sutekh/trunk/sutekh/sutekh/core/CachedRelatedJoin.py?revision=2873&view=markup. I considered contributing it back to SQLObject but it's a bit finicky to use -- one has to manually initialize the cache (see init_cache method) and then flush the cache (flush_cache) or just particular items (invalidate_cache_item) from within one's application as needed. Schiavo Simon ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
