News for hackers. Stuff that matters.
Re:Ask HN: Now can I cut down mySQL queries on dynamic pages? by minalecs on Monday March 28, 2011 @01:16PM (#2379120)
The only way to improve it is cache it for maybe x minutes, and then update cache. Maybe you should provide the reason why it can't be cached for say maybe 5 minutes. If its a problem where they are reloading, the homepage to see results then you could do incremental updates of each section using comet technique.
Re:Ask HN: Now can I cut down mySQL queries on dynamic pages? by thatusertwo on Monday March 28, 2011 @03:08PM (#2379605)
This is probably a more practical method.
Re:Ask HN: Now can I cut down mySQL queries on dynamic pages? by redredraider on Monday March 28, 2011 @12:48PM (#2379003)
If it has to be updated on every page load I don't think there's anything you can do...I may be wrong I'm sure someone on HN will have some performance tricks. You can generate your headers and footers and store them in a file instead of touching a database every time. If you're killing your database server you're probably returning too many records or your queries suck. I wouldn't know without seeing them.