volttron icon indicating copy to clipboard operation
volttron copied to clipboard

Separate tables for different base topics

Open jhaack opened this issue 8 years ago • 5 comments

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.

jhaack avatar Sep 15 '16 17:09 jhaack

Do we add a parameter or a configuration setting. This would need to be in all concrete historians

craig8 avatar Sep 16 '16 02:09 craig8

@schandrika Does recent work on historian query performance lessen the need for this?

jhaack avatar Oct 26 '16 19:10 jhaack

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 avatar Oct 26 '16 19:10 schandrika

@schandrika please comment on current status.

shwethanidd avatar Feb 19 '20 00:02 shwethanidd

@schandrika to do a performance test on production environment and scope work

schandrika avatar Feb 20 '20 21:02 schandrika