<https://lh3.googleusercontent.com/-JTTCeJzu3V0/VlgX4JxTCkI/AAAAAAAAAAo/K9fx7wj3LUc/s1600/694275B6-CFE4-49AE-81C1-51F80C67630A.png>


when  I  query a lot of record from mysql by session.query, which is one 
million more, 

and  the size of memory  reaches to 2G Byte , I want to release the memory 
*immediately 
, *

*but , try to some kind of method , it does not work *

*please  help !*

<https://lh3.googleusercontent.com/-JTTCeJzu3V0/VlgX4JxTCkI/AAAAAAAAAAo/K9fx7wj3LUc/s1600/694275B6-CFE4-49AE-81C1-51F80C67630A.png>





*在此输入代码...session_factory = sessionmaker(    autocommit=False, 
autoflush=True,     expire_on_commit=False, bind=engine)*


*Session = scoped_session(session_factory)Base = 
declarative_base()Base.query = Session.query_property()class 
ORMBase(object):    @classmethod    def getlist(cls, **kw):        return 
cls.query.filter_by(**kw).all()*

-- 
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/d/optout.

Reply via email to