Re: word index - is there a better solution?

[Craig Logan]

hey rick,

thanks for taking the time to reply;

I thought about fulltext search, but this isn't available for innodb and we'd like to be more flexible with the search words (i.e. we will have to index 2 character words). also, we want to do a lot more with the data (for example, we also intend to store the word order and calculate search result quality based on that).

sphinx and lucene don't work well with our distributed memcache system, so no go with that either.

well, I guess we'll see how many billion rows we can force into a single table. :)