SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Nov 23, 2008, 19:56 #1
- Join Date
- Jan 2004
- Location
- Cape Cod
- Posts
- 163
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Mysql storing results from a complex join in a second table
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
-
Nov 23, 2008, 20:01 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
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
-
Nov 23, 2008, 22:10 #3
- Join Date
- Jan 2004
- Location
- Cape Cod
- Posts
- 163
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Thanks I will look into your suggestions.
Bookmarks