ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 24,816
- Points
- 823
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...
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...