Re: [SQLObject] Temporary databases / Closing the :memory: database connection

[Oleg B. <ph...@ph...>]

On Thu, Oct 17, 2013 at 10:01:53PM +0100, "Maciej (Matchek) Blizi??ski" <ma...@op...> wrote:
> 2013/10/17 Oleg Broytman <ph...@ph...>
> import sqlobject
> 
> class Foo(sqlobject.SQLObject):
>   bar = sqlobject.UnicodeCol(length=250, unique=True)
> 
> db_uri = 'sqlite:/:memory:?cache=false'
> while True:
>   sqlobject.sqlhub.processConnection = sqlobject.connectionForURI(db_uri)
>   Foo.createTable()
>   sqlobject.sqlhub.processConnection.close()
>   sqlobject.sqlhub.processConnection = None
>   sqlobject.dbconnection.TheURIOpener.cachedURIs = {}
> 
> The process' memory kept growing. It started at around 30MB and was
> steadily raising up to 300MB

   It would be interesting to test if the problem lies in SQLite,
PySQLite or SQLObject.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.