Keşfet

Search failures - FTS query exceeds result cache limit

XFdestek

Kurucu Üye
Katılım
25 May 2014
Mesajlar
3,220
Tepkime puanı
284
Konum
Türkiye
Web sitesi
fivetu.xyz
We're regularly getting errors when people do searches on our forum, running on a DigitalOcean managed database. We recently migrated from VB3.8. I've tried adjusting cache limits to no avail. One example of a query that crashes below. Googling indicatesthat complex queries with lots of Boolean (which this is) can cause this problem.

This is, in theory a relatively simply query, a single word on a single thread. Why such a complex query? Any idea on fixes? Have been increasing the cache...

Lütfen içeriği görebilmek için Giriş yap yada Kayıt ol
 

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

Benzer konular

Geri
Üst Alt