[CASSANDRA-9230] Allow preparing multiple prepared statements at once

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Not A Problem
• Labels: ponies
• Assignee: Unassigned
• Reporter: Vishy Kasar
• Created: 23/Apr/15 18:05
• Updated: 16/Apr/19 09:31
• Resolved: 09/May/15 18:35

Description

We have a few cases like this:

1. Large (40K) clients
2. Each client preparing the same 10 prepared statements at the start up and on reconnection to node
3. Small(ish) number (24) of cassandra nodes

The statement need to be prepared on a casasndra node just once but currently it is prepared 40K times at startup.

https://issues.apache.org/jira/browse/CASSANDRA-8831 will make the situation much better. A further optimization is to allow clients to create not-yet prepared statements in bulk.This way, client can prepare all the not yet prepared statements with one round trip to server.