DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

qiuzeliang_194033 avatar image
qiuzeliang_194033 asked ·

请问频繁修改静态列,对Cassandra的读写性能是否有影响?

例如,我需要存储某个人的余额信息,这个数据只有一份,我希望将余额信息存储为静态列,每次修改只修改这个静态列,但是更新频率可能比较高,这样对Cassandra的读写性能是否有影响? 是不是需要修改所有sstables上的存储的静态列?

data modeling
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

不,它不会影响Cassandra reads或writes的性能。在带有clustering columns的表中,static column效率更高,因为对于分区中的所有行它只会更新一次。

它与没有clustering columns的表中的普通列没有什么不同。 根据定义,分区中没有行的所有列都是静态的。

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.