Re: [sqlalchemy] Re: memory of query cache not release when session close

2015-11-30 Thread Mike Bayer
On 11/30/2015 06:02 AM, Hongxin Song wrote: > > Although the all rows are paged into memory, they are cached by > identity map for query with loading once。 > Then the total size of memory dose not reduce. > Is that so? > and how can I clear identity-map or close indentity-map pattern?

Re: [sqlalchemy] Re: memory of query cache not release when session close

2015-11-30 Thread Hongxin Song
Although the all rows are paged into memory, they are cached by identity map for query with loading once。 Then the total size of memory dose not reduce. Is that so? and how can I clear identity-map or close indentity-map pattern? Thanks for your help! 在 2015年11月28日星期六

Re: [sqlalchemy] Re: memory of query cache not release when session close

2015-11-27 Thread Mike Bayer
On 11/27/2015 05:20 AM, Hongxin Song wrote: > In multithreaded scenarios , it is a serious problem , because the > server will be oom that's part of CPython, first see: http://effbot.org/pyfaq/why-doesnt-python-release-the-memory-when-i-delete-a-large-object.htm so once you use 2G of RAM,

[sqlalchemy] Re: memory of query cache not release when session close

2015-11-27 Thread Hongxin Song
In multithreaded scenarios , it is a serious problem , because the server will be oom 在 2015年11月27日星期五 UTC+8下午4:44:50,Hongxin Song写道: > > > > > > when I query