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

Reply via email to