Re: [SQLObject] Slow/Large cache

2012-09-06 Thread Oleg Broytman
On Thu, Sep 06, 2012 at 09:41:46AM +0200, Gert Burger 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

Re: [SQLObject] Slow/Large cache

2012-09-06 Thread Gert Burger
Oleg Broytman wrote, On 27/08/2012 10:57: > Hello! > > On Mon, Aug 27, 2012 at 10:32:50AM +0200, Gert Burger > wrote: >> We have a RPC server which CPU usage increases over time, after a week >> it will max out one core. >> >> >From my testing(Using pyrasite's dump stack) it seems that all the t

Re: [SQLObject] Slow/Large cache

2012-08-27 Thread Oleg Broytman
Hello! On Mon, Aug 27, 2012 at 10:32:50AM +0200, Gert Burger wrote: > We have a RPC server which CPU usage increases over time, after a week > it will max out one core. > > >From my testing(Using pyrasite's dump stack) it seems that all the time > is spend in: > > File > "/usr/local/lib/pyth

[SQLObject] Slow/Large cache

2012-08-27 Thread Gert Burger
Hi We have a RPC server which CPU usage increases over time, after a week it will max out one core. >From my testing(Using pyrasite's dump stack) it seems that all the time is spend in: file "/usr/lib/pymodules/python2.6/turbogears/database.py", line 275, in commit self.threadingLocal.connec