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.
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.
Viewing 3 replies - 1 through 3 (of 3 total)
The topic ‘wp_postmeta table structure’ is closed to new replies.