Re: [SQLObject] eagerly fetching joined objects

[Simon C. <hod...@gm...>]

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