memory-leak in pysqlite 2.3.0 ?

Marc 'BlackJack' Rintsch bj_666 at gmx.net
Mon Jun 19 17:49:07 CEST 2006


In <mailman.7193.1150711285.27775.python-list at python.org>, Michael Husmann
wrote:

> 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



More information about the Python-list mailing list