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!
Читать далее...
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!
Читать далее...
