O

Caching results of a query

  • Thread starter Thread starter Orit
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
O

Orit

Guest

Hi
I have a couple of custom widgets that execute database queries using finders. These queries don’t need to run frequently because the results do not change often.
Our forum board is fairly busy, sometimes with 6,000 simultaneous users, and executing these queries for every user is overloading our database and affecting performance.

How can I cache the results of these finder queries for at least 30 minutes, and then refresh the cache only when it expires?

Thanks!

Continue reading...
 
Similar content Most view View more
Back
Top Bottom