incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stuart Broad <stu...@moogsoft.com>
Subject Prepared Statement - cache duration (CQL3 - Cassandra 1.2.4)
Date Fri, 19 Apr 2013 11:57:47 GMT
Hi,

I am using Cassandra.Client prepare_cql3_query/execute_prepared_cql3_query
to create and run some prepared statements.  It is working well but I am
unclear as to how long the server side 'caches' the prepared statements.
 Should a prepared statement be prepared for every new Cassandra.Client?
 Based on my limited testing it seems like I can create some prepared
statements in one Cassandra.Client and use in another but I am not sure how
reliable/lasting this is i.e.  If I called the prepared statement again the
next day would it still exist?  What about if cassandra was re-started?

*Background:*
I am creating prepared statements for batch updates of pre-defined lengths
(e.g. 10000, 1000, 500, 250, 50, 10, 1) and wanted to know if these could
just be set up once.  We felt that using the prepared statements was easier
than escaping values within a CQL statement and probably more performant.

Thanks in advance for your help.

Regards,

Stuart

p.s. I am relatively new to cassandra.

Mime
View raw message