DISQUS

Brian,

There are two different techniques - one is adding pseudo keywords and other is using filters and "Full Table Scan" query.

Pseudo keywords works if there are few of them in the query and they are well selective.

If you will have 10 keywords each with 90% selectivity this would not work well.

Filters w full table scan however can be slower with good selectivity but you can have a lot of non selective filters with very low penalty.

Also note Sphinx "full table scan" has optimizations so it often can skip a lot of "blocks" based on filters which makes it kind of similar to indexed lookup

Как и все удивлен почему FastCGI не тестировался... Касаемо Lighttpd - reverse proxy у него несколько кривой не держит keep-alive что я думаю и является причиной тормозов в данном случае.