Automatically delete sessionmap in the database

masso6

Joined: 2009-12-17
Posts: 2
Posted: Thu, 2009-12-17 21:37

Hi, sorry for my poor english, I'm french...
First of all, thanks a lot for gallery2, that's a great picture CMS !

I've only one problem : The sessionmap table in the database is often very very big,
I've tried to see in the "maintenance" item in the backoffice if there's any way to scheduled the delete of this table, but don't find...

Anybody can help me ?

Thanks for your answer,

Best regards,

Vincent, the poor french man...
 
alecmyers

Joined: 2006-08-01
Posts: 4342
Posted: Fri, 2009-12-18 11:36

Set the Session Lifetime (Admin->general) to 15 minutes, then go to Maintenance (Admin->Maintenance) and run the "Delete User Sessions" task. I think the task effectively does run periodically, anyway, as the Sessions are aged out of the table when they past the set age, on a random basis, if not all at once. If the session table is too big, leave the lifetime set to a shorter value and they'll disappear sooner.
 
masso6

Joined: 2009-12-17
Posts: 2
Posted: Wed, 2009-12-30 09:43

Sorry for the delay (christmas fest...)

Thanks a lot for your answer and your reactivity.
I was afraid that this sessionmap problem was the "black point" of gallery, but it don't seems.

Kind regards,

Vincent