Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import timeit
- from cassandra.cluster import Cluster
- cluster = Cluster()
- session = cluster.connect()
- session.execute("CREATE KEYSPACE IF NOT EXISTS demodb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };");
- session.set_keyspace('demodb');
- session.execute("CREATE TABLE IF NOT EXISTS TMCR (p1 int, c1 int, r1 text, PRIMARY KEY (p1, c1));")
- bigstring = 'x' * 64 * 1024
- prepared = session.prepare("INSERT INTO TMCR (p1, c1, r1) values (1, ?, '{}')".format(bigstring))
- for i in range(32 * 1000):
- if i % 100 == 0:
- print("Now inserting", i)
- session.execute(prepared, [i])
- x = timeit.Timer(lambda: session.execute("SELECT * FROM TMCR WHERE p1 = 1"))
- print("Timeit", x.timeit(number=100))
Add Comment
Please, Sign In to add comment