Lots of updates to the same rows/columns could theoretically impact read performance. One way to help counter that would be to use the LeveledCompactionStrategy to keep the table optimized for reads. It could keep your nodes busier with compaction – so test it out.
Sean Durity From: Gábor Auth <auth.ga...@gmail.com> Sent: Tuesday, November 10, 2020 11:50 AM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Last stored value metadata table Hi, On Tue, Nov 10, 2020 at 5:29 PM Durity, Sean R <sean_r_dur...@homedepot.com<mailto:sean_r_dur...@homedepot.com>> wrote: Updates do not create tombstones. Deletes create tombstones. The above scenario would not create any tombstones. For a full solution, though, I would probably suggest a TTL on the data so that old/unchanged data eventually gets removed (if that is desirable). TTLs can create tombstones, but should not be a major problem if expired data is relatively infrequent. Okay, there are no tombstones (I misused the term) but every updated `value` are sitting in the memory and on the disk before the next compaction... Does it degrade the read performance? -- Bye, Auth Gábor (https://iotguru.cloud [iotguru.cloud]<https://urldefense.com/v3/__https:/iotguru.cloud__;!!M-nmYVHPHQ!cnmro4EqZM3gNHz8GNmzIFDZ29hTfdoqwoZbnVG07wpOhi2hoTNm7PeAyBGDvj0uEIfFPUA$>) ________________________________ The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.