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 -- http://mail.python.org/mailman/listinfo/python-list