Re: [SQLObject] One to 'a lot' relationship

[Ian B. <ia...@co...>]

Robert Leftwich wrote:
> What is the best (read fastest) way to handle a 1-many relationship in 
> SQLObject where the many is thousands of rows? The current 0.5.2 release 
> issues an individual select for every row on the many side, which is a 
> significant bottleneck. Is the SVN version better in this regard or do I 
> need to code up something specific for this situation? If SVN is the way 
> to go, is there a specific upgrade strategy I need to follow or can I 
> just uninstall 0.5.2 and install the SVN version w/o requiring db changes?

SVN is significantly better, though I actually thought 0.5.2 also did 
this properly.  Anyway, it's supposed to fetch all the columns on any 
select.

There's no database changes necessary to upgrade, but the main module 
has changed names from SQLObject to sqlobject, and MyClass(id) is now 
MyClass.get(id), and MyClass.new(**kw) is now MyClass(**kw).

-- 
Ian Bicking  /  ia...@co...  / http://blog.ianbicking.org