> On Mon, 19 Feb 2007, Gerd v. Egidy wrote: > > ; > * Auto-maintenance for AWL (ie pruning "old" entries) > ; > ; yeah, that would be a really good idea. > > We cheat here using MySQL based AWL with a timestamp column. The timestamp > column gets updated every time the row is updated so we can prune quite > easily.. delete from awl where tstamp < now() - interval 6 month;
That's what I do as well, but a) it only works with DB-based storage (and then only if the DB supports "auto-last-change-timestamp" columns) and b) it requires a separate process to do the pruning. -- Matthias
