Performance of Data Types used for Primary keys

2020-03-06 Thread Hanauer, Arnulf, Vodacom South Africa (External)
Hi Cassandra folks, Is there any difference in performance of general operations if using a TEXT based Primary key versus a BIGINT Primary key. Our use-case requires low latency reads but currently the Primary key is TEXT based but the data could work on BIGINT. We are trying to optimise where

Re: Performance of Data Types used for Primary keys

2020-03-06 Thread Jon Haddad
It's not going to matter at all. On Fri, Mar 6, 2020, 2:15 AM Hanauer, Arnulf, Vodacom South Africa (External) wrote: > Hi Cassandra folks, > > > > Is there any difference in performance of general operations if using a > TEXT based Primary key versus a BIGINT Primary key. > > > > Our use-case r

RE: [EXTERNAL] Re: Performance of Data Types used for Primary keys

2020-03-06 Thread Durity, Sean R
I agree. Cassandra already hashes the partition key to a numeric token. Sean Durity From: Jon Haddad Sent: Friday, March 6, 2020 9:29 AM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Performance of Data Types used for Primary keys It's not going to matter at all. On Fri, Mar 6, 2020, 2

Re: Performance of Data Types used for Primary keys

2020-03-06 Thread Reid Pinchback
If you care about low-latency reads, I’d worry less about columnar data types, and more about the general quality of the data modeling and usage patterns, and tuning the things that you see cause latency spikes. There isn’t just a single cause to latency spikes, so expect to spend a couple of m