scoped_session use threads only if you dont use scopefunc. On Saturday, February 15, 2014 2:05:33 AM UTC+4, Jonathan Vanasco wrote: > > I don't know if any of this will help - I'm too tired to read though all > your code: > > 1. Twisted isn't threadsafe, so anything happening in deferToThread needs > to be entirely encapsulated. This has totally screwed me up many times. > You should avoid a scoped_session , as it has to do with threads. > > 2. You can't expect anything in twisted to be reused. > > The safest way i've found, and I've only experimented on migrating my > twisted work to sqlalchemy : > > 1. Use a regular session for each request and explicitly pass it around. > never use scoped_session. > 2. Avoid threaded stuff as much as possible. For a while I had a > `deferToThread` that wrapped a `runInteraction` . That ended up causing a > memory leak ( threads spawning threads ). > > someone on this list was one trying to get scoped_session to work with > twisted, and there was a lot of code that he wrote to do it. there was > never an official update. >
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.