I am working on a project in which I have to store up to 10 custom fields per post. So if I have around 1,000 posts, the post meta table will have around 10,000 entires. In some instances, there may be only 3-4 custom fields per post but when the post is being displayed, it will try to search all the 10 fields and then load only those which exist.
I wanted to know that which of the following works best:
– Add new columns in wp_posts table & store custom fields in them
– Use the existing wp_postmeta table for storing custom fields
In other words, what I need to know is that if all the custom fields are stored in the wp-posts table, won’t this increase the speed and efficiency as compared to storing custom fields in wp_postmeta table and then calling them when each post is loaded.
