773 karma · joined March 15, 2009
Mostly that your believing Scylla marketing literature and paid benchmarks over what people actually use and experience. Theres thousands of large Cassandra deployments and a hand full of Scylla ones and it's not because people didn't do their research. If they did to ScyllaDB though it will probably kill the product, with Cassandra this is more of a positive for the community.
- SASI requires 2 passes on disk to fetch data: 1 pass to read the index files and 1 pass for the normal
Cassandra read path whereas search engines retrieves the result in a single pass (DSE Search has a singlePass option too).
By laws of physics, SASI will always be slower, even if we improve the sequential read path in Cassandra
- Although SASI allows full text search with tokenization and CONTAINS mode, there is no scoring applied
to matched terms SASI returns result in token range order, which can be considered as random order from the
user point of view. It is not possible to ask for total ordering of the result, even when LIMIT clause is used.
Search engines don't have this limitation
- last but not least, it is not possible to perform aggregation (or faceting) with SASI.
The GROUP BY clause may be introduced into CQL in a near future but it is done on Cassandra side,
there is no pre-aggregation possible on SASI terms that can help speeding up aggregation queries> These people tend to be drawn towards programming languages that are built out of small pieces with a consistent philosophy from the ground up, such as lisp or Haskell.
If you like go and dislike perl its to his point.
A TLDR (because apparently); People who like games that are complex because of complex rules like perl. People who like complex games with simple rules dislike it.