Nice tip and thanks :)
2013/5/8 Sebastian Willing <s...@cpan.org> > Thank you! > > On 07.05.2013 20:17, Gabor Szabo wrote: > > After some use of Trac the we encountered slowness of the system. > > Lately I noticed it happens when someone tries to access the user list, > > but only now did I check the database: > > > > sqlite> select count(*) from session_attribute; > > 781194 > > sqlite> select count(*) from session_attribute where authenticated <> 1; > > 774670 > > sqlite> select count(*) from session_attribute where authenticated = 1; > > 6538 > > > > sqlite> select count(*) from session; > > 300174 > > sqlite> select count(*) from session where authenticated <> 1; > > 298771 > > sqlite> select count(*) from session where authenticated = 1; > > 1403 > > > > In other words, about 99-99.5% of the sessions tables are used for > information > > about people who are not authenticated users. > > > > My solution: clean up the session tables, remove not-so-important > entries: > > delete from session_attribute where authenticated <> 1; > > delete from session where authenticated <> 1; > > > > And now the user list loads fast again. > > > > BTW here are the schemas of the the two tables: > > > > > > sqlite> .schema session > > CREATE TABLE session ( > > sid text, > > authenticated integer, > > last_visit integer, > > UNIQUE (sid,authenticated) > > ); > > CREATE INDEX session_authenticated_idx ON session (authenticated); > > CREATE INDEX session_last_visit_idx ON session (last_visit); > > sqlite> .schema session_attribute > > CREATE TABLE session_attribute ( > > sid text, > > authenticated integer, > > name text, > > value text, > > UNIQUE (sid,authenticated,name) > > ); > > > > > > Gabor > > _______________________________________________ > > Padre-dev mailing list > > Padre-dev@perlide.org > > http://mail.perlide.org/mailman/listinfo/padre-dev > > > > _______________________________________________ > Padre-dev mailing list > Padre-dev@perlide.org > http://mail.perlide.org/mailman/listinfo/padre-dev >
_______________________________________________ Padre-dev mailing list Padre-dev@perlide.org http://mail.perlide.org/mailman/listinfo/padre-dev
