Thanks Oleg, You are very kind because you reply for my question, even if the question is discussed in this mailing-list again and again.
I had already tried the patch by Dan, but nothing is changed. You posted that: 1. how about connection.cache.clear() ? 2. memory is freed for python, but python doesn't return memory to OS. I want to clear the cache only for the object I want to delete, thus I want to avoid 1.(and 1. doesn't solve this problem). 2. is doubt, because python returns memory to OS in the following code(as posted in previous mail). class NormalObject: name = "dummy" obj_list = [] for i in xrange( 10000 ): obj_list.append( NormalObject ) # memory grows del obj_list[:] # memory freed This problem is a frequently asked question, and it is natural that "I want to free the object from memory, because it is stored in DBMS." I treat the objects with RDBMS which has > 100,000,000 rows, thus this is very serious problem... On Wed, 13 Sep 2006 21:21:39 +0400 Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Thu, Sep 14, 2006 at 01:40:20AM +0900, ?$B6L1[Bg51 wrote: > > hmm, it seems that an object inherites SQLObject is not freed, but a > > plain object is freed. > > There is a patch created by Dan Pascu <[EMAIL PROTECTED]> that may fix > that. Can you test it (attached)? Does it help? > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] > Programmers don't die, they just GOSUB without RETURN. -- 株式会社ビービット 玉越 大輝 ユーザビリティ コンサルタント beBit,Inc. Tamakoshi Hiroki [EMAIL PROTECTED] -------------------------------------------------------- 〒105-0001 東京都港区虎ノ門1-18-1 虎ノ門10森ビル7F TEL: 03-3509-7602 / FAX: 03-3509-7605 URL: http://www.bebit.co.jp/ -------------------------------------------------------- ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss