Multiple tables versus comma separated entries or searlization?
So, I am developing a project management plugin that allows for multiple projects, users, apps, etc. I’ve worked out my database schema to do what I need correctly I should really create 7 or more tables in the WordPress database and just use join statements to query the data I need.
Or, I could do the same thing with about 3 tables if I store a lot of information in comma separated strings that I explode and implode or serialized arrays. Generally, I’ve been told to normalize my databases without regard to how many actual tables I need.
What is the best practice here for WordPress? Is creating that many tables with a plugin a problem?
Thanks for the input.
- The topic ‘Multiple tables versus comma separated entries or searlization?’ is closed to new replies.