CraigM wrote:So the event log history auto prune is the only item causing excessive growth?
Hard to say. Each device state change will cause a new row in the database, as will each variable value change. You definitely don't need to keep a year of event log data in the history database (just keep the raw log files if you want to keep a year or more worth of data). I would keep just a day or two, and even then if you don't have any plugins or scripts that are querying the event log table then you don't need it at all.
Because the database has gotten so large it might be having a hard time pruning the old entries after you changed the history popup. From your Event Log snippet, it looks like Indigo timed out waiting on the plugin to respond. If it doesn't work (prune and result in a smaller file), then I'd suggest just renaming the SQLite database file (append "- backup" or something on it) so the plugin can start with a fresh history database. You'll still have the old data if you need to reference it in the future.
