Cassandra Prepared Statements

benchmark.rb

require 'cassandra'
require 'benchmark/ips'

cluster = Cassandra.cluster(hosts: ["192.168.59.103"])
session = cluster.connect

session.execute("CREATE KEYSPACE benchmark WITH REPLICATION = { 'class': 'SimpleStrategy', 'replication_factor': 2 }")
session.execute("USE benchmark")
session.execute("CREATE table reads (test_one text PRIMARY KEY, test_two text)")

5_000.times do |i|
  session.execute("INSERT INTO reads (test_one, test_two) VALUES ('#{i}', 'benchmark')")
end


Benchmark.ips do |x|
  x.time = 60
  statement = session.prepare("SELECT * FROM reads where test_one = ?")

  x.report("Without a prepared statement") do
    100.times { |i| session.execute("SELECT * FROM reads WHERE test_one = '#{i}'") }
  end

  x.report("With a prepared statement") do
    100.times { |i| session.execute(statement, arguments: ["'#{i}'"])}
  end

  x.compare!
end

session.execute("DROP KEYSPACE benchmark")