Mysql storing results from a complex join in a second table

[Donniep]

Hi All,
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.

Thanks
Don

[r937]

there are several types of caching

mysql offers caching, and so does every application language (e.g. php)

i would advise you to investigate those options before going to the unusual extreme of "saving" data in your own database table

[Donniep]

Thanks I will look into your suggestions.