On Thu, Sep 06, 2012 at 09:41:46AM +0200, Gert Burger <[email protected]>
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/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
