volttron
volttron copied to clipboard
Separate tables for different base topics
Make separate tables for: analysis, devices, record, etc. This will require separate topic tables as well for each.
Add a parameter to historian query to direct to the appropriate table. Default table is current data table.
Do we add a parameter or a configuration setting. This would need to be in all concrete historians
@schandrika Does recent work on historian query performance lessen the need for this?
Historian queries are still slower when getting data for more than a couple of weeks. I am not sure about the impact of this though as we now support queries across multiple topics. I think this is still worth investigating and running some quick tests.
@schandrika please comment on current status.
@schandrika to do a performance test on production environment and scope work