search

MangoAutomation / ma-core-public

Mango Automation Core public code
Other
79 stars 50 forks source link

is pointvalues table dataType filed nessary? this is redundancy and use disk space #1636

Closed huanghe-1 closed 4 years ago

huanghe-1 commented 4 years ago

pointvalue's datatype is decide by datapointVo,one certain datapoint have one certain pointvalue type,if it is nessary,it can be remove,much more dataype is same value "3".

terrypacker commented 4 years ago

This field is there so that when extracting data from the pointValues table we don't have to JOIN on the dataPoints table. This way we can convert the point value data into the correct data type and use a single column pointValue to store the data instead of having a column for each data type. It is arguable that it is the most performant way to achieve this. But we have the Mango NoSQL module for high performance and storage optimization.