memory-leak in pysqlite 2.3.0 ?

Michael Husmann Michael.Husmann at teleatlas.com
Mon Jun 19 05:54:36 EDT 2006


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




More information about the Python-list mailing list