Difference between revisions of "Database structure"
From PhotoVoltaic Logger new generation
m |
m (→pvlng_reading_num / pvlng_reading_str) |
||
| Line 21: | Line 21: | ||
== pvlng_reading_num / pvlng_reading_str == | == pvlng_reading_num / pvlng_reading_str == | ||
| − | [[File:DBTableReadingNum.png]][[File:DBTableReadingStr.png]] | + | [[File:DBTableReadingNum.png]] [[File:DBTableReadingStr.png]] |
| + | |||
| + | The timestamps are '''not''' stored as "normal" timestamp type, but as '''unsigned integer'''. | ||
| + | |||
| + | It was tested and have significant more performance for consolidated data readouts. | ||
Revision as of 16:33, 2 March 2014
Contents
Abstract
pvlng_type
pvlng_channel
pvlng_tree
The channel tree is organized in a nested set structure.
The nested set model is a particular technique for representing nested sets (also known as trees or hierarchies) in relational databases. -- Wikipedia:Nested set model
More theory about nested sets.
pvlng_reading_num / pvlng_reading_str
The timestamps are not stored as "normal" timestamp type, but as unsigned integer.
It was tested and have significant more performance for consolidated data readouts.
