Hi all,
'Twas brillig, and Michael Renzmann at 24/03/09 10:30 did gyre and gimble:
> Which database are you using?
SQlite. I meant to mention this originally, but must have slipped my mind :$
'Twas brillig, and Remy Blank at 24/03/09 09:52 did gyre and gimble:
> How big is your session table?
>
> select count(*) from session;
>
> If it is very large, you may want to purge it from stale entries (users
> that have been removed from the system).
There are 84542 rows here. Is this a lot? Doesn't sound like much, but
who knows :)
Is there a handy way to purge this based on non-existent users?
Or would something like:
DELETE FROM session where authenticated=0 and last_visit <
(strftime('%s','now') - 24*60*60*7);
do the job fine?
If so, is there not some built in purging that goes on? Or perhaps a
plugin to randomly do this every 100 requests or something?
'Twas brillig, and Christian Boos at 24/03/09 11:02 did gyre and gimble:
> Well, that's easy to tell - simply disable that plugin for a while, and
> see if things improve (even if this is on a production server, the
> temporary annoyance for your users this will cause won't be greater than
> when they get a db lock ...).
Good point! I should have thought of that :s
Thanks everyone for your help. I'll look into everything and report back.
Col
--
Colin Guthrie
gmane(at)colin.guthr.ie
http://colin.guthr.ie/
Day Job:
Tribalogic Limited [http://www.tribalogic.net/]
Open Source:
Mandriva Linux Contributor [http://www.mandriva.com/]
PulseAudio Hacker [http://www.pulseaudio.org/]
Trac Hacker [http://trac.edgewall.org/]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Development" 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-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
