I would also like to know the performance difference for Cassandra's secondary index vs. DSE's solr indexing placed on CF's.
We have a few CF's that we did not place secondary indices on because we were under the impression that secondary indices would (eventually) cause significant performance issues for heavy read/write CF's. We are trying to turn to Solr to allow for searching these CF's but it looks like loading an index schema modifies the CF's to have secondary indices on the columns of interest.
Would like to know if Solr indexing is different than Cassandra's secondary indexing? And, will it eventually cause slow queries for large data sets in a heavy read/write CF? If so, would you advise custom indexing (which we wanted to avoid)? Btw -- we're also using (trying to use) Solr for it's spatial searching.
Thanks for any advice you can give.