Full Text Search with SphinxWe had a look at Sphinx Search. This provides direct APIs to MySQL, and ODBC to other databases. Their most well-known user is Craiglist. Looks very scalable, especially if you can shard the indexes.
SELL ALL signal revisitedPeople started with using the 200 day moving average, then later found that the 250-day moving average (the 52-week moving average) was superior...