On Mon, Apr 28, 2008 at 08:43:41PM +1200, David McNab wrote:
> class Foo(SQLObject):
> someattr = IntCol()
> otherattr = StringCol()
> things = MultipleJoin("Thing")
>
> class Thing(SQLObject):
> attr1 = BoolCol()
> attr2 = StringCol()
> foo = ForeignKey("Foo")
>
> But if the database grows to having tens of thousands, even millions of
> rows in each table, then accessing '.things' could prove pretty slow.
See my previous message to the list about SQLMultipleJoin.
> Another option is to look into dynamic creation of tables, where for
> each Foo object I create a dynamic Thing-like class.
Do you mean dynamic creation of *rows*?
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
