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.