Keşfet
Kullanıcı:
Filtreler

Caching results of a query

XFdestek

XFdestek

Kurucu Üye
Katılım
25 May 2014
Mesajlar
3,201
Tepkime puanı
284
Konum
Türkiye
Web sitesi
fivetu.xyz
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!
 
Cevap yazmak için giriş yap yada kayıt ol.

Konu görüntüleyen kullanıcılar

Toplam: 2 (Kullanıcı: 0, ziyaretçi: 2)
Benzer konular Forum Tarih
XFdestek TypeError: XF\Mvc\Entity\AbstractCollection::toWebhookResults(): Argument #1 ($options) must be of type array, int given, called in /src/XF/Api/Result Xf2 Genel 0 16
XFdestek [vbresults.com] Custom PHP Pages Xf2 Genel 0 19
XFdestek Odd copy/pasting behavior for search results resulting in H2/every word italicized Xf2 Genel 0 27
XFdestek File health check results have time error Xf2 Genel 0 29
XFdestek Make XenForo requirements script results more accurate and robust for all server setups Xf2 Genel 0 35
XFdestek Search Results via API Xf2 Genel 0 31
XFdestek Improve table formatting for Json/ld 'rich results' Xf2 Genel 0 43
XFdestek Exclude XFMG media results from search Xf2 Genel 0 39

Benzer konular

Geri
Üst Alt