recently, I have been studying the scheme of sub-database and sub-database. I don t have much experience. If you have any questions, I will ask you for advice. for example, an order table with fields: placing an order for id, goods, id, store, id, iss...
every amount change of the user is recorded in this table. website users about 100W, now the table is too big, thought of sub-table, how to divide it? Table structure! user id is a 32-bit guid ...
to query the data after horizontal split, suppose the data of a business is split horizontally, and the monthly records are stored in a table. The data of each table is about 1000w. There are already more than 20 tables, such as table_201606,.,table_201...