Matt Burgess created NIFI-3425:
----------------------------------
Summary: Cache prepared statements in PutCassandraQL
Key: NIFI-3425
URL: https://issues.apache.org/jira/browse/NIFI-3425
Project: Apache NiFi
Issue Type: Improvement
Reporter: Matt Burgess
Priority: Minor
Currently PutCassandraQL supports prepared statements (using ? parameters much
like JDBC SQL statements) via flow file attributes specifying the type and
value of the parameters.
However, the prepared statement is created (and thus possibly re-created) for
each flow file, which neuters its effectiveness over literal CQL statements.
The driver warns of this:
2017-01-31 14:30:54,287 WARN [cluster1-worker-1]
com.datastax.driver.core.Cluster Re-preparing already prepared query insert
into test_table (id, timestamp, id1, timestamp1, id
2, timestamp2, id3, timestamp3, id4, timestamp4, id5, timestamp5, id6,
timestamp6) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);. Please note
that preparing the same query
more than once is generally an anti-pattern and will likely affect
performance. Consider preparing the statement only once.
Prepared statements should be cached and reused where possible.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
