[dev] [Nic] Added feature: purge old records

[Roel Gloudemans]

et voila, here it is. The patches with the discussed changes.

Cheers,
Roel.

Quoting Jan Schneider <jan at horde.org>:

> Zitat von Roel Gloudemans <roel at gloudemans.info>:
>
>>> and the purging should be integrated into statusMonitor.php. Not
>>> that it should be run each time the status gets updated, but with some
>>> clever interval depending on the purge days.
>> I'm wondering. If you run it each time with statusMonitor, it will 
>> delete one
>> monitoring cycle and add another, this then will be a kind of round robin
>> database. I don't know how e.g. mysql is handling this exactly, but it
>> is using
>> freed space from earlier deletes. Also, if the information per cycle 
>> differs a
>> lot; fragmentation could take place.
>>
>> Options to do it otherwise:
>> 2) if the oldest record is more than a day older than set set treshold
>> run purge
>> 3) Create an entry in the datatree; or a file in vfs to record the last
>> time run
>>
>> I'm leaning towards 2 since it requires no extra storage elements
>
> Ah, I didn't have in mind that the script doesn't know how often it runs.
> Yeah, 2 sounds good in this case.
>
> Jan.
>
> -- Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
> -- Horde developers mailing list - Join the hunt: http://horde.org/bounties/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>




-------------- next part --------------
A non-text attachment was scrubbed...
Name: purge.patch
Type: text/x-patch
Size: 6750 bytes
Desc: not available
Url : http://lists.horde.org/archives/dev/attachments/20041029/c31f1391/purge.bin