Experienced users in CMS development should share the content table with the master table and the appendix.

Source: Internet
Author: User
If you are experienced in CMS development, do you want to split the content table into the master table and the Appendix? someone gave me a suggestion today. we recommend that you split the data table into two tables: the content table and the master table, what are the benefits of doing so? I have seen some CMS do this. ------ Solution ------------------ easy to expand and maintain in the later stage. Easy to modify. ------ Solution ------------------ the main table has a great deal of experience in developing CMS for the subsequent multi-statement presentation. should the content table be divided into the main table and the attached table?
Someone gave me a suggestion today. we recommend that you split a data table into two tables in the master table. What are the advantages of this solution? I have seen some CMS do this.

------ Solution --------------------
It is easy to expand and maintain in the future. Easy to modify.
------ Solution --------------------
The main appendix provides great help for later releases !!!
------ Solution --------------------
It is necessary to have a large data scale.

This is a simple vertical table shard, which has some benefits. More data is saved on the unit Data page to reduce IO throughput.
------ Solution --------------------
It is recommended that the primary table and the attached table be highly efficient.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.