more good 0.4 news / buildbot

1 view
Skip to first unread message

Michael Bayer

unread,
May 26, 2007, 6:24:09 PM5/26/07
to sqlal...@googlegroups.com
ive been doing some tinkering with the way mappers and properties
load up, specifically for loading a group of 10 items with 50 child
items each, in a single eager-loaded query. ive managed to get the
total number of calls for the load to below 0.2.8 levels, so im
pretty psyched:

python test/perf/masseagerload.py --verbose (using the version thats
in the latest trunk / 0.4 branch)

0.4 branch: 66958 function calls (64401 primitive calls) in 0.382
CPU seconds
trunk: 82002 function calls (76432 primitive calls) in 0.629 CPU
seconds
0.3.7: 81874 function calls (76231 primitive calls) in 0.405 CPU
seconds
0.3.4: 73623 function calls (71091 primitive calls) in 0.357 CPU
seconds
0.2.8: 77344 function calls (76316 primitive calls) in 0.444 CPU
seconds

im also hoping that polymorphic loading is going to be a lot easier
in this release, as you can load across multiple mappers without
using any unions (in exchange for a lot more SELECTs issued). The
SELECTs can either be issued immediately or using a "deferred"
scheme, like a deferred column group.

in other news, Ben Bangert has been so kind as to donate part of his
hosting space for a SQLAlchemy buildbot, which is specifically
against SA builds (unlike the "main" SA buildbbot which is against
the Python trunk). its over at: http://pylonshq.com:8012/ . anyone
who feels like donating a slave (such as to test firebird, windows,
etc.) can jump right on.

Reply all
Reply to author
Forward
0 new messages