> If your site is very busy, and you have many users
> who do not log out after reading their mail (this happens when a user
> does not click on the [logout] menu option when finished, or when
> netscape aborts before you can click on [logout]), then the session
> record in "active_sessions" stays there for good, and as a result,
> the database just keeps on growing in size, until it becomes a sysad
> problem.
Hi Doc.
I'm not familiar w/ MySQL or your datamodel but if your active_sessions has
a timestamp column then you can delete from active_sessions where the time
difference between now and the timestamp is greater than some value.
Hmm. This is pretty obvious so you've probably already thought of it and for
some reason or another it won't work with your setup, otherwise you wouldn't
have posted your problem.
:-)
Brian
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
