Sphinx for searching Memcached for caching MongoDB for analytics Can anyone compare the Lucene and sphinx performance?
Comment: Sphinx search performance optimization: attribute-based filters
… works well for highly selective attributes. If attributes only have few distinct values (e.g status, gender, group_id with only 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too.

