Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- import uuid
- import time
- def do_some_writes(conn, rowcount, autocommit=True):
- add_row = ("INSERT INTO mark (s) values (%s)");
- cursor = conn.cursor()
- for _ in xrange(rowcount):
- cursor.execute(add_row, (str(uuid.uuid4()),))
- if autocommit:
- conn.commit()
- conn.commit()
- cursor.close()
- if __name__ == '__main__':
- rowcount = 1000
- conn = mysql.connector.connect(user="root", password="12345", host="mysql", database="marktesting")
- for autocommit in [True, False]:
- start_time = time.time()
- do_some_writes(conn, rowcount, autocommit=autocommit)
- end_time = time.time()
- print "Time to insert %d rows with autocommit = %s: %f" % (rowcount, autocommit, end_time - start_time)
- conn.close()
Add Comment
Please, Sign In to add comment