fix the advanced search SQL backend

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :| :mrgreen: :geek: :ugeek: :arrow: :angel: :clap: :crazy: :eh: :lolno: :problem: :shh: :shifty: :sick: :silent: :think: :thumbup: :thumbdown: :salute: :wave: :wtf: :yawn: :facepalm: :bravo: :dance: :beard: :morebeard: :xmas: :HeHe: :trollface: :cookie: :rainbow: :monkeysee: :monkeysay: :happybday: :headwall: :offtopic: :superhappy: :terms: :beer:
View more smilies

BBCode is ON
[img] is OFF
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: fix the advanced search SQL backend

Re: fix the advanced search SQL backend

by joedf » 15 Dec 2022, 11:07

It looks like sphinx could be the fastest option, but no guarantee and it does require some setup with possible significant space usage/overhead

Re: fix the advanced search SQL backend

by swagfag » 14 Dec 2022, 17:22

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

by tank » 14 Dec 2022, 11:40

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

by joedf » 14 Dec 2022, 09:53

I'll send tank a direct message and ask him again.

Re: fix the advanced search SQL backend

by swagfag » 13 Dec 2022, 19:01

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

by joedf » 16 Jan 2022, 15:18

@tank
Perhaps we could also give this "Sphinx" search backend a try? apparently is it much faster...

fix the advanced search SQL backend

by swagfag » 15 Jan 2022, 10:35


Top