> upgrade to 0.5.5 for starters. around version 0.5.2 we killed an immense > speed issue in the session that was brought about by sessions with large > numbers of objects.
Great, this is good to know and I will start with that. > second thing, this would apply to either, do the session.commit() every > 100 objects or so, which can reduce how many objects continue to hang > around in memory. OK. > thirdly, querying 18000 objects at once requires that they all be loaded > at once. You may want to use yield_per() or load many "windows" of > results using limit()/offset(). > > for #2 and #3, using 0.5.5 again is extremely recommended since the > Session also is able to drop references to objects fully as of the same > 0.5.2 release, so memory usage will be improved. OK, I was wondering about the memory issues. Thanks very much for this information! Brian --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
