In <[EMAIL PROTECTED]>, 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
--
http://mail.python.org/mailman/listinfo/python-list
