Store a large number of data points?

Question

What is the best way to store a large number of data points?

For example, temperature values ​​that are measured every minute in many places?

Single row SQL databases on data points do not look very efficient.

Answer 1

I would like to know why you think this is "inefficient." You probably need to explain your data model and schema to give a better script context.

, , . , , .

, , . 3-5 30-60 . , , .

, , . (Clustered index) . .

Answer 2

: ?

, , .

OTOH, , .

- , / .

Answer 3

Such a table may work:

LocationID, temperature, timestamp

I do not understand why this would be inefficient. After all, these are databases.