Page 1 of 1
fix the advanced search SQL backend
Posted: 15 Jan 2022, 10:35
by swagfag
Re: fix the advanced search SQL backend
Posted: 16 Jan 2022, 15:18
by joedf
@tank
Perhaps we could also give this "Sphinx" search backend a try? apparently is it much faster...
Re: fix the advanced search SQL backend
Posted: 13 Dec 2022, 19:01
by swagfag
swagfag wrote: ↑15 Jan 2022, 10:35
DDOS the forum by searching
Posts and Messages with a single wildcard
*
lol, still not fixed apparently...
Re: fix the advanced search SQL backend
Posted: 14 Dec 2022, 09:53
by joedf
I'll send tank a direct message and ask him again.
Re: fix the advanced search SQL backend
Posted: 14 Dec 2022, 11:40
by tank
i dunno what you mean by DDOS with a single wildcard. Yes YOUR session will become unusable during the course but it would take many such sessions occuring at the same time to DDOS and there are other mechinisms in place to account for that
Re: fix the advanced search SQL backend
Posted: 14 Dec 2022, 17:22
by swagfag
ah ok, i dont see whats going on with the rest of the forum in the background once i lock myself out. i just get a cloudflare page so i assumed everybody did
then maybe reduce the query timeout down to like 5 mins. i just retested it and it locked me out for about an hour
Re: fix the advanced search SQL backend
Posted: 15 Dec 2022, 11:07
by joedf
It looks like sphinx could be the fastest option, but no guarantee and it does require some setup with possible significant space usage/overhead