Hello,
I am using the data logger as well as the weatherSnoop plugin where I am collecting data from weatherUnderground stations.
It comes very handy and works beautifully, however I have a couple problems that I would like to solve.
First of all, for each weather agent device, the logs on the database contain the whole data of the weather agent rather than just the one it is configured to give (for example temperature or humidity). This means that for each weather parameter I want to see in the interface, the database logs 20+ data columns, and this n time if n is the number of parameter (in my case 5). Therefore, I end up with 5 copies of the same large tables in my database. I was wondering if there could be a fix for that. For example selective logging of some of the agents only.
Second, (and I think it is essentially the same problem as in http://forums.indigodomo.com/viewtopic.php?f=98&t=11715), in each of this databases, the data entries seem to update only one column at a time, which means that for a particular timestamp, I may have 15+ almost identical copies of the same line essentially.
As you can easily understand, I am a bit worried that having 5 times the copy of a large table which itself as 10 copies of each of its line (also considering that the logs are done at a relatively fast rate that I cannot seem to be able to control) might make the database blow up in size quite quickly, and the logging is quite important for me so I would like to limit the expansion of the database as much as possible.
Any advice ?
Thanks in advance