WordPress.org

Ready to get started?Download WordPress

Forums

wp_postmeta table structure (4 posts)

  1. webhope
    Member
    Posted 4 years ago #

    Hi,
    I start using meta for my posts. I wondered when I had seen the structure of table wp_postmeta. I thing that the structure is absolutely crazy. Why I page has about 5 records? Why don't you do something simple for 1 record per page?

    I would suggest this model:
    meta_id, post_id, _edit_lock, _edit_last, _aioseop_description, _aioseop_title, _aioseop_keywords ... and thats all guys!

    meta_value values goes to relevant column (one of these: _edit_lock, _edit_last, _aioseop_description, _aioseop_title, _aioseop_keywords).

    In this model you don't need do 5 db qerries per page! Just one.

  2. webhope
    Member
    Posted 4 years ago #

    I think this problem is mentioned here, but I'm not so good in English to understand that surely.
    http://thedeadone.net/forum/?p=1283

  3. webhope
    Member
    Posted 4 years ago #

    And I have similar problem with
    meta_key: _edit_lock
    http://wordpress.org/support/topic/221227?replies=11
    coz I want to generate this value outside this script and I don't know what is this value for? And how to generate it.
    Anybody helps?

  4. webhope
    Member
    Posted 4 years ago #

    Somebody should create new module to fix the unusual structure of wp_postmeta. For example create new table wp_postmeta_2 and new module. After activateing the main script it would just asked if WP has newet or older version and it would use corresponding module for postmeta.

Topic Closed

This topic has been closed to new replies.

About this Topic