in reply to Re: Re: Maintaining state with CGI.pm
in thread Maintaining state with CGI.pm

Another method of cleaning out old entries is to do so every time you enter a new entry. (I use this a lot with shopping carts and the like.) Make sure every row in the table has a timestamp for when it was created and modified, then have a single DELETE statement remove all entries before a cutoff date. (half a day, 1 week, etc.)

-franknmonk
  • Comment on Re: Re: Re: Maintaining state with CGI.pm