Clean Database - delete records older than x days
Posted: Thu Jul 10, 2014 9:17 pm
Hello,
I implemented a OWL device to check power.
Working well; I use database saving values and in my web interface, I use highcharts to plot the history (highcharts.com).
Now, I have too many records in my database and I'd like to clean it for records older than x days.
The idea is to launch an event (midnight ?) to clean database every day.
Until now, I didn't found the method... do you have any idea ?
Kind regards.
I implemented a OWL device to check power.
Working well; I use database saving values and in my web interface, I use highcharts to plot the history (highcharts.com).
Now, I have too many records in my database and I'd like to clean it for records older than x days.
The idea is to launch an event (midnight ?) to clean database every day.
Until now, I didn't found the method... do you have any idea ?
Kind regards.