i have a question regarding the efficiency of word press database structure.
My intended application will hold 3 custom post types and about 20-30 fields for each post type.
The basic structure of wordpress db requires me basically for each published post to have 30 insert actions once a new post is published … is it the best way to go ?
if i will have 5000 posts (which will be there after 1 year) i will have a wp_post_meta of 150,000 rows … how efficient is that will i experience performance issues ?
As i see it as the table will get longer and longer it will have an impact on its efficiency.
or am i getting it totally wrong ?
The Table wp_postmeta has an index on the columns post_id and meta_key. Therefore a JOIN with the wp_posts table will be very fast an it will not need too many resources.
I do have databases with tables which hold more than 7 million rows. I do a lot of INSERT into and JOIN statements into these tables. But as I have an index on each important column, you don’t really recognize, that these tables have millions of rows.