>From Duy Hai DOAN's blog http://www.doanduyhai.com/blog/?p=2058 :
Please note that SASI does not intercept DELETE for indexing. Indeed the > resolution and reconciliation of deleted data is let to Cassandra at read > time. SASI only indexes INSERT and UPDATE. > With this it feels that Lucene is better if you have use-case of frequent deletes on CF as it marks documents deleted and will be cleaned later. Though I dint find any doc mentioning how SASI indexes are cleaned after grace period expired for the tombstone. Will it be remove or not? Ideally it should be removed. Also fetching functionality of lucene 'filter' search and SASI is also sequancial, i.e. no scatter gather. Does it worth to migrate to SASI if your column family face heavy deletes too. --------------------------------------------------------------------------------------------------------------------- Atul Saroha *Sr. Software Engineer* *M*: +91 8447784271 *T*: +91 124-415-6069 *EXT*: 12369 Plot # 362, ASF Centre - Tower A, Udyog Vihar, Phase -4, Sector 18, Gurgaon, Haryana 122016, INDIA
