On any given day a blog could have several entries posted on it. As such I have two options (using MySQL and PHP):
- To give the entries table a date/timestamp column and repeat dates and times.
- To create three tables: entries, date and time and inner join them.
This may seem like an utterly barmy question, however I'm considering how much 'bloating' option A would cause in comparison to whether there is any performance gain/loss with that many inner joins?
As an example:
If 2 people posted at the same time every day, there would be 730 instances a year (732 on a leap year!) of that time in the database. Is that enough of a concern to warrant indexing and joining three tables?