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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
