GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Gfy(lite) A Solution to the search feature.

colpanic · 10-16-2004, 02:01 PM

Sure.

I wasn't suggesting a solution to the DOS problem.. A seperate set of boxes is the way to fly for that.

I was addressing the problem that search is slow as balls when it DOES work , which is because the way searches are run is inefficient. (this makes it easier to DOS too)

Fast search at a minimum requires reverse indexes, which is the opposite of what SQL does.. (short explanation: normal SQL search would scan each post for the word "dog", causing every post to be read during a search... a reverse index would build an index of each word.. so when you search for dog it would just go look up that word in the hash, and return all the pages in the index)

Or are you saying that this stuff is taken care of already by the vBulliten search if GFY just configured it properly?

10-16-2004, 02:01 PM
colpanic Confirmed User Join Date: May 2004 Location: San Diego, CA Posts: 1,007	Sure. I wasn't suggesting a solution to the DOS problem.. A seperate set of boxes is the way to fly for that. I was addressing the problem that search is slow as balls when it DOES work , which is because the way searches are run is inefficient. (this makes it easier to DOS too) Fast search at a minimum requires reverse indexes, which is the opposite of what SQL does.. (short explanation: normal SQL search would scan each post for the word "dog", causing every post to be read during a search... a reverse index would build an index of each word.. so when you search for dog it would just go look up that word in the hash, and return all the pages in the index) Or are you saying that this stuff is taken care of already by the vBulliten search if GFY just configured it properly? __________________ I like ducks.