Michael Bayer wrote:
[snip]
actually a lot better than they've been in the past.  if your tests are
useful, I might add them as well (but note that your attachments didnt
come through, so try again).

I forgot the attachments, sorry. Please find them here:

http://d2.spacespa.it:8000/temp/test-userhandling.py
http://d2.spacespa.it:8000/temp/userhandling1.py
http://d2.spacespa.it:8000/temp/userhandling2.py

one thing that could make ORM loads much faster would be if you knew
the objects would not need to be flushed() at a later point, and you
disabled history tracking on those instances.  this would prevent the
need to create a copy of the object's attributes at load time.

How can I disable the history tracking?

[snip]

Strangely, your last commit doesn't seem to bring any speed
improvements. Last measurements:

user handling with ORM
Starting test
Total time: 76.4469230175

real    1m17.088s
user    0m22.097s
sys     0m0.348s


user handling without ORM
Starting test
Total time: 44.6131839752

real    0m45.185s
user    0m8.561s
sys     0m0.228s


I'd also like to know how to improve the userhandling2.py file. I have
some doubts about the life-cycle of session objects. Is it better to
create and destroy them at each transaction, or to make them long
lived?

thanks in advance
david


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to