memory-leak in pysqlite 2.3.0 ?

[Michael Husmann]

After upgrading from pysqlite 2.0.5 to pysqlite 2.3.0 writing into a
sqlite database increases memory consumption heavily. A similar program
with Ruby and sqlite-ruby 1.1.0 does not affect memory consumption at
all.

Here a short example:
-------------------------------
#!/usr/bin/env python

import os
from pysqlite2 import dbapi2
print dbapi2.version

db = dbapi2.connect("bla.db")
c = db.cursor()

c.execute("create table b (c integer)")

for i in xrange(10000000):
c.execute("insert into b values (%d)" % i)

----------------------------------

System in use:
Python 2.4.1, Sqlite3 3.3.6, Pysqlite 2.3.0

Regards,
Michael

 

[Marc 'BlackJack' Rintsch]

After upgrading from pysqlite 2.0.5 to pysqlite 2.3.0 writing into a
sqlite database increases memory consumption heavily. […]

Here a short example:
-------------------------------
#!/usr/bin/env python

import os
from pysqlite2 import dbapi2
print dbapi2.version

db = dbapi2.connect("bla.db")
c = db.cursor()

c.execute("create table b (c integer)")

for i in xrange(10000000):
c.execute("insert into b values (%d)" % i)

Just a guess: Commit the changes from time to time.

Ciao,
Marc 'BlackJack' Rintsch