sys_sessions table in 7.0.3

This table is collecting the sessions and it's getting bigger and bigger. Any damage if I'm truncating the table from time to time?

Quote · 10 Nov 2011

Your daily cron is supposed to clear it every days I think?

 

In my daily cron job it says:

 

Deleted sessions: xxx
Quote · 10 Nov 2011

You can also write your own cron that clears sys sessions daily, 2x day, weekly, etc. if dolphin doesn't do it with the default cron. I have had to write my own php file along with a cron to clear it because dolphin won't empty the sessions. It got huge and it was a pain manually doing it so I wrote a php file and added it to cron 2x daily.

DialMe.com - Your One and Only Source For Boonex Dolphin Tutorials and Resources
Quote · 10 Nov 2011

As for me, I run these two SQL requests from time to time:

 

DELETE FROM `sys_sessions` WHERE `sys_sessions`.`user_id` = 0;

 

DELETE FROM `sys_sessions` WHERE `sys_sessions`.`date` < 1303784178;

!!! replace 1303784178  with the latest date to delete

Life is a fatal disease, sexually transmissible - Virginity is carcinogenic! Ask here for vaccine.
Quote · 10 Nov 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.