i t looks to me that the sql logger stores entries several times, especially from devices with multiple properties: e.g. a query against a thermostat results in ~70% double / triple entries for temperature with the same date/timestamp and same value. I guess this is due to the fact that some of the updates from the thermostat come in independently and each of the changes triggers a save of all properties.
If the double / triple would be 1-5 % I would understand but 70% waste!
Anything one can do about it , i.e. a clean up sql script? ... that is well beyond my current SQL level.
Karl