Searching the board is back[views:1879][posts:8]______________________________________ [Jan 31,2006 9:33am - the_reverend ""] 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. |
| ________________________________________ [Jan 31,2006 11:34am - Joe/NotCommon ""] Dude, guy kid man west side. |
| ___________________________________ [Jan 31,2006 11:35am - succubus ""] sorry, searching disabled... you didn't thnk I would see you searching from here, but I do you sneaky bastard. |
| ___________________________________ [Jan 31,2006 11:36am - succubus ""] i got that msg aaron ^^^ and how dare you callme a sneaky bastard! |
| _______________________________________ [Jan 31,2006 11:49am - the_reverend ""] the text version isn't back yet, sorry. |
| ___________________________________ [Jan 31,2006 11:52am - succubus ""] 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 |
| _______________________________________ [Jan 31,2006 11:55am - the_reverend ""] 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. |
| ___________________________________ [Jan 31,2006 11:57am - succubus ""] add spell check feature : ) actually nevermind...if you do you'd REALLY slow down the server while is corrects errors... |
| _______________________________________ [Jan 31,2006 12:02pm - the_reverend ""] *rimshot* |