Ass Hat
Home
News
Events
Bands
Labels
Venues
Pics
MP3s
Radio Show
Reviews
Releases
Buy$tuff
Forum
  Classifieds
  News
  Localband
  Shows
  Show Pics
  Polls
  
  OT Threads
  Other News
  Movies
  VideoGames
  Videos
  TV
  Sports
  Gear
  /r/
  Food
  
  New Thread
  New Poll
Miscellaneous
Links
E-mail
Search
End Ass Hat
login

New site? Maybe some day.
Posting Anonymously login: [Forgotten Password]
returntothepit >> discuss >> Searching the board is back by the_reverend on Jan 31,2006 9:33am
Add To All Your Pages!
toggletoggle post by the_reverend   at Jan 31,2006 9:33am
I turned it back on, but I may have to shut it off again if my fix doesn't like totally work dude.
I'm actually still going to re-write the searching algorithm to include fulltext based searches, but that would increase the indexing on the database by something like times 3 (from 9MB to 44mb) which increases the whole discussion databade like about a 3rd (from 95MB to 130MB).

please, do not abuse this feature as it still not the "best" solution and can still lock up the database. thankfully, I turned a query that was taking between 10 and 45 seconds into one that takes between .1 to 3 seconds.



toggletoggle post by Joe/NotCommon   at Jan 31,2006 11:34am
Dude, guy kid man west side.



toggletoggle post by succubus  at Jan 31,2006 11:35am
sorry, searching disabled... you didn't thnk I would see you searching from here, but I do you sneaky bastard.



toggletoggle post by succubus  at Jan 31,2006 11:36am
i got that msg aaron ^^^

and how dare you callme a sneaky bastard!



toggletoggle post by the_reverend   at Jan 31,2006 11:49am
the text version isn't back yet, sorry.



toggletoggle post by succubus  at Jan 31,2006 11:52am
oh and the message that "Searching is disabled" is still visible but maybe that's on purpose since you don't want to encourage it



toggletoggle post by the_reverend   at Jan 31,2006 11:55am
I guess.. I need to re-do the searching and do fulltext index searches. I just didn't write that yet.
I also want to put in a date selector that defaults to 1 month.

I guess the "feature" I need to really make it work more slick is in MySQL 5.. but I'm not bleeding edge enough to upgrade to that yet.



toggletoggle post by succubus  at Jan 31,2006 11:57am
add spell check feature : )

actually nevermind...if you do you'd REALLY slow down the server while is corrects errors...



toggletoggle post by the_reverend   at Jan 31,2006 12:02pm
*rimshot*



Enter a Quick Response (advanced response>>)
Username: (enter in a fake name if you want, login, or new user)SPAM Filter: re-type this (values are 0,1,2,3,4,5,6,7,8,9,A,B,C,D,E, or F)
Message:  b i u  add: url  image  video(?)show icons
remember:Blasphemous Iced Saint
[default homepage] [print][3:25:10pm Apr 26,2024
load time 0.02926 secs/15 queries]
[search][refresh page]