Guest User

Untitled

a guest
Jul 23rd, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. import timeit
  2. from cassandra.cluster import Cluster
  3.  
  4. cluster = Cluster()
  5. session = cluster.connect()
  6.  
  7. session.execute("CREATE KEYSPACE IF NOT EXISTS demodb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };");
  8. session.set_keyspace('demodb');
  9.  
  10. session.execute("CREATE TABLE IF NOT EXISTS TMCR (p1 int, c1 int, r1 text, PRIMARY KEY (p1, c1));")
  11.  
  12. bigstring = 'x' * 64 * 1024
  13. prepared = session.prepare("INSERT INTO TMCR (p1, c1, r1) values (1, ?, '{}')".format(bigstring))
  14. for i in range(32 * 1000):
  15. if i % 100 == 0:
  16. print("Now inserting", i)
  17. session.execute(prepared, [i])
  18.  
  19. x = timeit.Timer(lambda: session.execute("SELECT * FROM TMCR WHERE p1 = 1"))
  20. print("Timeit", x.timeit(number=100))
Add Comment
Please, Sign In to add comment