Re: Temporary databases / Closing the :memory: database connection

On Thu, Oct 17, 2013 at 10:01:53PM +0100, "Maciej (Matchek) Blizi??ski" <[email protected]> wrote:
> 2013/10/17 Oleg Broytman <[email protected]>
> 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/            [email protected]
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk