# expire the session itself after 1 idle hour
$session->expire('+1h');
[download]

Update Made 'doc' a link to the relevant section of the documentation

Sorry I didn't include enough detail in my first post. I'm using CGI::Session and I have my sessions expire set at 30 minutes:

$session->expire('+30m')

My problem is that my MySQL database keeps filling up with sessions that I want to delete after they are expired. I was thinking about parsing the epoc out of the a_session field, but I am looking for a more elegant way to clean the expired sessions out of the database.

Thanks

I see. I haven't used CGI::Session before, but perhaps you could use a combination of $session->atime, $session->expire, localtime, and $session->delete to get something like this pseudo-code:

$session->delete if (($session->atime + $session->expire) < localtime)
+;
[download]

well, you've got to find the date in the database somehow. Parsing out the timestamp is annoying, indeed. The way I would probably do it would be to have another field in the database of type datetime, and every time the session updates something it sets that field to now(). That way you can easily delete from tablename where.

If changing what goes into the database is not an option, then you're probably stuck parsing out the date... unless you do something like create temp files on disk holding (or named after) the values of the primary key of your table.

LAI