Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import MySQLdb
- import mysql.connector
- from DBUtils.PooledDB import PooledDB
- from time import time
- def pool(lib):
- return PooledDB(lib, host="localhost", user="test", passwd="test", db="test")
- def conn(lib):
- return lib.connect(host="localhost", user="test", passwd="test", db="test")
- def timeit_pool(steps, pool):
- start = time()
- for a in range(1,steps):
- conn = pool.connection()
- cursor = conn.cursor()
- cursor.execute("Select %s, %s;", ('a',1))
- result = cursor.fetchone()
- cursor.close()
- conn.close()
- return time()-start
- def timeit_wo_pool(steps, conn):
- start = time()
- for a in range(1,steps):
- cursor = conn.cursor()
- cursor.execute("Select %s, %s;", ('a',1))
- result = cursor.fetchone()
- cursor.close()
- conn.close()
- return time()-start
- steps = 10000
- print timeit_pool(steps, pool(MySQLdb)), 'MySQLdb + pool'
- print timeit_pool(steps, pool(mysql.connector)), 'mysql.connector + pool'
- print timeit_wo_pool(steps, conn(MySQLdb)), 'MySQLdb'
- print timeit_wo_pool(steps, conn(mysql.connector)), 'mysql.connector'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement