- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,408
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.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...
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...