Re: [SQLObject] SQLObject Speed ?

[Stef T. <st...@um...>]

On 05/22/2009 02:21 PM, Matthew Wilson wrote:
> <snip>
> I find myself using SQLBuilder tools *a lot*.  Maybe I should read the
> code and see if I can help at least write some documentation for others,
> because I've had to figure out most of this stuff through trial and
> error.
>
> Matt
>    
Hello Matt, Everyone,
     I am wondering.. do you notice any speed issue's when doing 
instantiations of objects (complex or otherwise) ? I have a page that 
instantiates about 7000 booking objects. When I replace them with mocks 
(or pypo's) then I see the page render in about 0.3 seconds.. when I use 
SQLObject it goes upto about 80-90 seconds ... curiously, replacing the 
SQLObjects with SQLAlchemy objects I got the page rending in 2 seconds.

     This is why I was thinking it was object instantiation rather than 
mass inserts that was 'slow' .. perhaps my test doesn't display the 
slowness I am seeing, although I maybe hard pressed to come up with a 
test case that adequately replicates the slowdown :(

     Regards
     Stef
(ps. I am not 'knocking' SO in anyway, nor saying SA is "great".. merely 
wondering if it's only me being "special" :D