Hello,
the Dashboard is getting slower and slower with the whole data.
Does sombody have a quick and dirty soulution to erase the "submitted_work" and the "work_data" every 24h ?
I thougt about dropping every 24h the data from hour 0 -> 23 ... so i keep some stats (like hashrate of the last hour).
If i make my cronjob working ... i let you know ... if somebody does allready have one please let me know
cheers
the Dashboard is getting slower and slower with the whole data.
Does sombody have a quick and dirty soulution to erase the "submitted_work" and the "work_data" every 24h ?
I thougt about dropping every 24h the data from hour 0 -> 23 ... so i keep some stats (like hashrate of the last hour).
If i make my cronjob working ... i let you know ... if somebody does allready have one please let me know
cheers
How big is your database? Mine is at 19MB and my dashboard still loads in under a second. I have about 4-5 days worth of data in there. This is the same speed I get when accessing the dashboard from work as well, while it is hosted on a little web server in my basement.