I am attempting to create a custom plugin and would like some advice/ideas on how best to store the data.

Expected Posts ~ 1,000 Expected Users ~ 10,000

Each user will need to have at least one value stored PER post.

Is the best way to do this by adding new columns to the user_meta table?

Just looking for some guidance on the most efficient method so I don't bloat my db unneccesarily.

Thanks.

I am attempting to create a custom plugin and would like some advice/ideas on how best to store the data.

Expected Posts ~ 1,000 Expected Users ~ 10,000

Each user will need to have at least one value stored PER post.

Is the best way to do this by adding new columns to the user_meta table?

Just looking for some guidance on the most efficient method so I don't bloat my db unneccesarily.

Thanks.

• customization
• database

• It’s a little bit hard to guess what numbers (and how many of them) are you storing based on the description above - could you explain it a little bit more? – Krzysiek Dróżdż Commented May 28, 2019 at 4:50
• So are you just saying that each business will have a "total" number and a "current" number, and when anyone uses the button on their page, both of those should increase by 1 and be displayed? It sounds like you can just create a "business" CPT and use postmeta - but it depends on whether you'll ever want to query by those numbers. If so you should make a custom taxonomy for the numbers so that those queries will run faster. – WebElaine Commented May 28, 2019 at 15:20

1 Answer 1

The number in the above example are not indicative of a need for a custom database table solution, the database will be fine with just using the users table for the users, posts table for the posts and usermeta table for the link between users and posts.

Its hard to offer a more definitive answer without knowing a little more about what the needs of the business / plugin are to be.