kapua icon indicating copy to clipboard operation
kapua copied to clipboard

Device Event cleanup task

Open Coduz opened this issue 4 years ago • 1 comments

Is your feature request related to a problem? Please describe. it would be nice to have a task which removed obsolete Device Events which now makes the dvc_device_event table very big after a while. This also affects performance of retrieval like shown with issue #2851

Describe the solution you'd like A job which runs periodically and deletes device events which are older than a certain date.

The TTL 90(?) is by account and capped at system level by a property. As a proposal, if a device has less than 100(?) events we will keep them in order to have some history of that device.

This task will run periodically and will keep the device event table with few device events.

Describe alternatives you've considered None

Additional context Work to improve the performance and usability of the platform.

Coduz avatar Jul 07 '20 14:07 Coduz