Re: [SQLObject] eagerly fetching joined objects

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:hod...@gm...] 
Sent: Thursday, July 21, 2011 1:32 AM
To: Simon Laalo
Cc: sql...@li...
Subject: Re: [SQLObject] eagerly fetching joined objects

Hi

On Thu, Jul 21, 2011 at 2:07 AM, Simon Laalo
<sl...@re...> 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