www.beta.xyphos.com
this is my "testlive" of my items database. sorry for the all green, but it's not ment to look pretty.
anywho, I've updated the item search engine;
and this time, I think I've solved my name indexing issues by using a very dirty work-around.
basically, I've ditched the failed fulltext indexes and added 2 extra tables to reference each word in every item.
I want you to test the modified search engine.
the other features on beta have been disabled on purpose.
search for items on the beta version and report anything about the search engine that you find wrong, or if it takes more then 2 seconds to yield results.
if all works out, It'll hit the live version by next week, and CIDB will utilize it also when it goes live.
EDIT:
searching for "Might Rev" or "O.E.T. Co." works properly now.
EDIT 2: CIDB isn't hooked into the beta, so searching on CIDB will still use the old borked live search engine until I know the beta engine works.
(this is called prototyping.)