As far as I concerned, prepared statements eliminate the need of constantly parsing and preparing statements on the cassandra's side thus speeding up queries by a few hundred microseconds and decreasing the overall latency. But "A few hundred microseconds" doesn't seem as a thing I would go for to increase cluster performance. Do prepared statements also affect CPU/Memory usage, duration of GC calls or something else and if so then how exactly? Are there any artifacts of load tests that compare prepared and regular statements?
We have a cluster of 6 nodes running Cassandra 3.11.3 executing 30-40K CQL requests per minute at average
Thank you.