Re: [Tikiwiki-devel] A lot of of locked mysql queries in tiki_sessions table. Any ideas to avoid this?

[Stephane C. <se...@lo...>]

Le Thu, Aug 28, 2008 at 08:03:43AM -0400, Louis-Philippe Huberdeau écrivait :
> On August 28, 2008 03:57:22 Stephane Casset wrote:
> > Le Wed, Aug 27, 2008 at 04:40:52PM -0400, Louis-Philippe Huberdeau 
> écrivait :
> > > Sessions in trunk shoud have improved performance, little hard to test
> > > without taking it live thought.
> >
> > Why do you think trunk is any better ?
> > I remember having changed a query that  was only needed when session
> > where held in db. But I don't remember other « optimizations » :(
> >
> > May be we should add indexes, or change to innoDB instead of MyIsam
> > tables ?
> >
> > A+
> 
> I made some changes to preference management. It only stores the values that 
> changed from the defaults in the session, which reduced the serialized 
> session size from 35kb ro 2.5kb. That alone makes a huge difference.

Yes, but for the request involved, it does not, or I am missing
something ? 

Anyway any enhancement is welcome ! ;p

Maybe we shoudl just backport them to the 2.0 branch, as I am ot to
confident in upgrading tiki sites with trunk...

A+
-- 
Stéphane Casset            LOGIDÉE sàrl       Se faire plaisir d'apprendre
1a, rue Pasteur        Tel : +33 388 23 69 77           ca...@lo...
F-67540 OSTWALD        Fax : +33 388 23 69 77           http://logidee.com