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
- 28,804
- Points
- 823
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...
Read more
Continue reading...
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...
Read more
Continue reading...