Hi ,
What is efficient way to insert multiple rows in cassandra db from java.
I am using spring-data and it took 2 minutes to insert 600 rows
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:
- Haven't heard back about exams or vouchers? [NEW August 7]
- When can I book an exam? [NEW August 10]
- How do I qualify for an exam voucher? [NEW August 10]
- How long are the coupons valid for? [NEW August 10]
- Why can't I see my old exam result or certificate? [UPDATED August 10]
- What happened to my previous exam voucher? [UPDATED August 10]
- Why is my previous course progress not shown on the new Academy?
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
What is a more efficient way to insert multiple partitions with spring-data-cassandra?
Hello,
The bottleneck of inserting these 600 rows maybe not Spring Data Cassandra, but spring boot.
If your Cassandra code is used from the spring boot and invoked via HTTP, you may want to consider increasing the number of threads in spring (thread pool)
Regarding Spring-Data-Cassandra and possible performance improvements:
1. If you are using CqlTemplate, consider reworking your logic to async version: AsyncCqlTemplate, or reactive: ReactiveCqlTemplate
2. Leverage PrerparedStatement (instead of SimpleStatement) and use it in subsequent queries to reduce overhead when sending each query
3. Use BatchStatement to batch N statements that will be sent as a one batch request.
5 People are following this question.
