what's a reasonable upper bound on PreparedStatement caching?

2013-08-18 Thread Michael Cohen
If i'm doing some CQL query like: select * from table where id in (?,?,?,?...) but the bind parameters are variable length, because the keys are actually stored in a set column of another CF, I would potentially have many, many PreparedStatements being compiled (and cached I assume), potentia

reuse PreparedStatements?

2013-08-03 Thread Michael Cohen
More specifically, is it "best practice" to reuse PreparedStatements, rather than creating a new one via session.prepare() on each database access? Is there any performance benefit to this? I've glanced at the java driver code and it does appear that if I were doing something like: public List fe

should you reuse PreparedStatements?

2013-08-03 Thread Michael Cohen
More specifically, is it "best practice" to reuse PreparedStatements, rather than creating a new one via session.prepare() on each database access? Is there any performance benefit to this? I've glanced at the java driver code and it does appear that if I were doing something like: public List fe