[eluser]charlieD[/eluser]
I'm setting up an app and am trying to decide between a couple of different approaches for setting up the MySQL database.
The first approach would mean nicely detailed data which I don't think I'd use, for the moment at least.
The second approach would be to keep a summary table with the data I will be using, and this would save a lot of rows being created.
I can see the main table becoming very large (possibly millions of rows), and going with the detailed data would mean this table could be 5 or 10 times the size. The table will be queried very frequently.
My question is when it would be best to keep the detailed data which technically is a better database design, or go for saving query time and use the summary data.
I hope this makes sense,
Thanks
