Please tell me about the database design.
Sorry for the very basic question.
I am having trouble deciding how to design a table when there are a large number of data items.
I want to collect data every second from a control device.
The device has 8,191 points of data from X1 to X1FFF, and I would like to know what kind of design should be done when considering a table to store the data of all these points.
I thought of two patterns.
pattern A
A table that stores data in columns.
I don’t have much knowledge about table design, but I feel that this method is not a good idea because it cannot handle cases where the number of data points increases in the future.
However, since the data fits in one record, is it easy to handle? I also feel that.
pattern B
How to have data in row direction.
This way the columns are very simple and the fields are clear.
However, in this case, a huge amount of 8,191 rows of data are added every second, so the storage will likely fill up quickly.
I would like to know what measures should be taken when designing tables that handle such large amounts of data.
Sorry for the elementary question.
thank you.