Mysql storing results from a complex join in a second table
We are beginning work on a new news site and I am a bit worried about the number of queries needed to make it work. So I was searching around and saw one option that might work as a start to the problem. I read that it is possible to do a complex join then store this info in another table so that I would not have to perform the join again until there is a change in the database.
So I am wondering if anyone here has tried this method or if there is a better way of doing this. I plan on caching as much of the content as possible already I am just trying to do all I can to avoid any possible problems.