Thanks for your reply. I am using SQLite (crap) I cleaned the session table. More than 3 millon records were deleted. I only left the ones that session.authenticated=1.
The session_attribute table has millons of recors more than the session table. I guess that it is because the purge proccess is not working propperly. Can I consider doing this? DELETE FROM session_attribute WHERE authenticated=0; Thanks! On Jan 17, 6:25 pm, Matthew Caron <[email protected]> wrote: > On 01/17/2012 04:08 PM, Rodrigo wrote: > > > Hello, I the company where I work we are using trac 0.11.7 > > > We are getting many database locks and it is really slow when someone > > tries to log in. > > If you are using SQLite and have more than a few users, you should > switch to a RDBMS designed for greater workloads. > > -- > Matthew Caron > Build Engineer > Sixnet |www.sixnet.com > O +1 518 877 5173 Ext. 138 > F +1 518 602 9209 > [email protected] -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
