There is a table, 100 million per day in data volume, under the condition of constant hardware, how do you design the table?

CodePudding user response:

At least partition, how do you answer?

CodePudding user response:

According to the time interval to do partition, this article must have;

CodePudding user response:

Partition intervals,,,

CodePudding user response:

I wipe, the company did not want you, hardware structure remains the same, 1 billion data, per day in a year is 365 billion records, zha partition, also play,

CodePudding user response:

reference 4 floor jdsnhan response:

I brush, that company didn't want you to, hardware structure remains the same, 1 billion data, per day in a year is 365 billion records, zha partition, also play ah,

1,,,

CodePudding user response:

The perspective of thinking:
1, first to understand what this table is for, if this is the historical data archive, the table don't need to build a primary key and index,
2, build the partition table, deeper, to understand the existing hardware, if multiple hard, will be different partitions were built in different hard disk, which can significantly improve performance,
3, ask the demand, considering block set a bit bigger
4, understand the source of data, if it be from other tables to write, the big table can use batch write way,
,,,
This question is vague, must first agree on external demand and the environment,
Oracle in performance, there is no best only better, especially for different needs, plan is different,

CodePudding user response:

Wait for god to answer, very want to learn more knowledge of database