wp_postmeta versus new table

  • tsimion

    (@tsimion)


    15 years, 7 months ago

    Hi,

    I’m working on a plugin that will create a new custom post type (podcast) and each post will have extra attributes such as: file URL, # of downloads, last time listened, type and other 3. (a total of 7 attributes)

    So if the blog will have 10 podcast posts, then it will also have at least 70 attributes,
    100 podcast posts => 700+ attributes
    1000 => 7000+
    and so on.

    Some of these attributes will be used by to sort or filter podcast posts in the admin area. For example: a “Popular podcasts” section would sort by ‘# of downloads’ DESC.

    I’m finding it difficult to decide whether to use WP’s own wp_postmeta table or create a new table with these attributes as columns + post_ID as foreign key, to store this data.

    Which design would you choose and why?

The topic ‘wp_postmeta versus new table’ is closed to new replies.