Re: [SQLObject] Slow/Large cache

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

On Thu, Sep 06, 2012 at 09:41:46AM +0200, Gert Burger <ger...@gm...> wrote:
> Most of our inserts occur in small batches which wont benefit much from
> bypassing SQLO. From my profiling it doesn't seem like that is the problem.
> 
> It seems like the expiredCache for each table is growing continuously.
> Since my last email the size of expiredCache for some tables have grown
> to over a million entries and it never seems to decrease. In total the
> expired caches have about 4 million entries over all tables and current
> memory usage(150MB RES) doesn't match that amount of objects(of row data).
> 
> So my next question is, how do I prevent the expired caches from growing
> uncontrollably? For some reason the weak references are staying active
> and therefore they are not removed from the caches.

   Call connection.cache.clear() after a batch of insertions.

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