A solution to the database design of WordPress

Source: Internet
Author: User
About the database design of WordPress
Read an article on the Internet that the WordPress data table using the form of key-value pairs, so that the design of fewer fields, faster query. is the database query field less quickly than the number of fewer bars? And it's this key-value pair design, sometimes an article has 4, 5 key-value pairs, then this table is very easy to bar number will be very much, will not affect performance.
------Solution--------------------
The associative array of PHP is the form of a key-value pair, which is the specific implementation of the hash table
Key-value pairs are specific implementations of metadata (metadata)
Widely used in NoSQL databases
SQL database is a relational database, so the idea of implementing metadata in it is more difficult.

Simulation of NoSQL behavior in SQL, due to the lack of internal support of the database system, but only with the script to implement
Obviously, efficiency is low.
It's like an ORM in some framework, which is clearly a matter of writing a SQL command directly.
It's going to be torn apart. To pass the parameters through multiple methods and then assemble them into SQL instructions
Can you say that he will be more efficient? It's just that it looks like a self-deception.
  • 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.