What are the effects of vertical splitting?

The effects of vertical splitting are: 1. The splitting of the database is simple and clear, and the splitting rules are clear; 2. The application modules are clear and clear, and the integration is easy; 3. Some table associations cannot be completed at the database level and need to be Completed in the program; 4. Transaction processing is relatively more complex.

Advantages of vertical splitting

• The splitting of the database is simple and clear, and the splitting rules are clear;

• The application modules are clear and easy to integrate;

• Data maintenance is convenient and easy to locate;

Disadvantages of vertical segmentation

• Some table associations cannot be completed at the database level and need to be completed in the program;

• For extremely frequent access and Tables with extremely large amounts of data still have slow performance and may not necessarily meet the requirements;

• Transaction processing is relatively more complex;

• Segmentation reaches After a certain level, scalability will encounter limitations;

• Over-read sharding may make the system too complex and difficult to maintain.

In view of the data segmentation and transaction problems that may be encountered in vertical segmentation, it is really difficult to find a better solution at the database level. In actual application cases, the vertical segmentation of the database mostly corresponds to the modules of the application system. The data sources of the same module are stored in the same database, which can solve the problem of data association within the module. Between modules, the required data is provided to each other through application programs in the form of service interfaces. Although this will indeed increase the overall number of operations on the database, it is beneficial in terms of the overall scalability of the system and the modularization of the architecture.

The single response time of some operations may be slightly increased, but the overall performance of the system is likely to be improved to a certain extent. And the expansion bottleneck problem.

Recommended tutorial: "mysql tutorial"

The above is the detailed content of What are the effects of vertical splitting?. For more information, please follow other related articles on the PHP Chinese website!