Per second have a set of monitoring data, the data quantity about 150 sensors, 900 bytes,

In the future need to have the basic operations, such as historical query

Excuse me, how to set the primary key in the database? With the time line not line?

CodePudding user response:

The good is on the column,

CodePudding user response:

Can make a primary key date + sequence, convenient segmented query requirements

CodePudding user response:

Sequence, then how ah a year, a data per second

In time, ok?

CodePudding user response:

Cyclic sequence ah, every day started out as a minimum

CodePudding user response:

reference 4 floor wyqxrj response:

cycle sequence ah, every day begins with minimum

Thank you, that at the time of history query, query in time? Dice the sequence number here? Database is a small white, give advice or comments please