Today, open your eyes, find it in a B2C Ecommerce system, Items in the ECommerce database server.
(A product called an item called an item) related table, number of 99 columns. In addition, two warehouse, the SCM database server has ITEM tables, and three remain synchronized
First, the description of the Item itself is a lot; secondly, three servers will use some different fields when using Item, for handling convenience, equivalent to the redundancy of some fields per table; this table It is extremely high, so you need to minimize the associated query to improve efficiency, so put some other tables (possibly related query) also pulls to this table.
Hoho, the system is big, is it going to develop in this direction?
