i'm building my own backend for a news portal, and am starting to worry about server load
on the index page alone i've got
1 sql query to get latest 3 news stories
1 sql query to get latest 3 features stories
1 sql query to get recent newsbriefs
1 sql query for list of recommended links
1 sql query for active forum discussions
1 sql query for recommended music
thats 6 queries per hit on that page
so i'm wondering the best way to approach this
the only thing that changes often, is the 'active forum discussions'
everything else changes when a mod script updates the db. i'm thinking that aside from updating the db, when a mod adds something new, it could generate a new include file, that just has the html for that section -- so id only be hitting the db when modding those sections, not when retrieving
the question then -- is what would be faster/easier server load -- and what might the difference be? negligible or significant?
if anyone has insight, i'd love to hear it
on the index page alone i've got
1 sql query to get latest 3 news stories
1 sql query to get latest 3 features stories
1 sql query to get recent newsbriefs
1 sql query for list of recommended links
1 sql query for active forum discussions
1 sql query for recommended music
thats 6 queries per hit on that page
so i'm wondering the best way to approach this
the only thing that changes often, is the 'active forum discussions'
everything else changes when a mod script updates the db. i'm thinking that aside from updating the db, when a mod adds something new, it could generate a new include file, that just has the html for that section -- so id only be hitting the db when modding those sections, not when retrieving
the question then -- is what would be faster/easier server load -- and what might the difference be? negligible or significant?
if anyone has insight, i'd love to hear it