[ZODB-Dev] using ZODB w/IIS and memory leak

[John.N.1@bwc.state.oh.us]

Hello there,

I've been playing with ZODB to use as a simple pythonesque database. It
makes life simpler than even pickeling and doesn't have the complexities of
a major database.

I've also had problems . . .

Perhaps someone has an idea.

I have attempted to use ZODB w/IIS. An ASP page will load up information
from a ZODB database.

However, every time the page is loaded, memory is not reclaimed until all
the memory on the box is used. (it's loading about a 10 megabyte database).
Read-only or not, the memory is still used and not reclaimed.

Here's some example test code from an ASP page.

   try:
	if read_only: 
	    storage =
FileStorage.FileStorage(sys_dir+'/data/tmp/test-filestorage.fs',read_only=1)
	    db = DB( storage )
	    conn = db.open()  #use finally to close it
	    root = conn.root()
	    a=str(root['big']['ex'][1])+'re-open
connection'+str(round(time.time()-begin))
	    return a
	else:
	    storage =
FileStorage.FileStorage(sys_dir+'/data/tmp/test-filestorage.fs')
	    db = DB( storage )
	    conn = db.open()  #use finally to close it
	    try:
		root = conn.root()
		a=str(root['big']['ex'][2]) #then do something w/a
	    finally:
		db.close() #if db.open succeeds, the finally ensures
db.close called


Even if I explicity go through and del the variables so the vars() builtin
shows all the ZODB stuff as gone, the memory is still not reclaimed.

Any clues?

Thanks,

john