Distributed storage has become the trend of the large amount of data storage,
Oracle also have the table partitioning technology,
Problem a
1, under the premise of a hard disk: I put the order into 12 tables TORDER_01... TORDER_12 VS a table, cut in 12 monthly table space
A high efficiency?
2, now most of the server's hard disk is 1 t plate, common database server, that is, to put one or two set, so the question here:
Why can't a database server, make into 100 g a dish, even 10 g a dish?

CodePudding user response:

1, under the premise of a hard disk: I put the order into 12 tables TORDER_01... TORDER_12 VS a table, cut in 12 monthly table space
A high efficiency?
The latter if for the partition table, the effect is not much different, but the former you want to query across a month, but several times to query;


2, and now most of the server's hard disk is 1 t plate, common database server, that is, to put one or two set, then the problem here:
Why can't a database server, make into 100 g a dish, even 10 g a dish?
Server hard disk 100 g a, there are 36 g a, when the amount of data for 100 t, to prepare the area of the room, there are differences;

CodePudding user response:

For your first question, you should consider, from the advantages of the partition table to only use the partition table when it is advantageous to use it, isn't it ~

CodePudding user response:

The main aim of the partition is easy to manage, easy to maintain, high availability, the efficiency is not the main point of the
Most servers use disk array, the array of each disk is not large, how is hundreds of G