Today I converted the SproutSearch database from InnoDB to MYISAM. I wanted to use fulltext searching, which InnoDB does not support. I didn't really need transactions either. The indexes now use about 100M less space.

I rewrote my search queries to use the new fulltext index. My phrase building script now runs a lot faster, and I have been up all night adding keywords for it to find.

So what I have so far is a little over 900 pages of keyword pages which display related blogs. The next step is to create a directory structure to organize the keywords into similar groups. Right now these pages are all on a list, which is more for search engines to look at than people. I am hoping the search engines will gobble up the new content.