Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import time
- import ceODBC
- import pyodbc
- dsn = "<insert your dsn here>"
- data = 1000 * [(1, "testing", 5555.5555)]
- def multi_insert(odbc):
- conn = odbc.connect(dsn)
- crs = conn.cursor()
- crs.execute("""
- CREATE TABLE ##test (
- field_int int,
- field_vc varchar(50),
- field_dec decimal(10, 5)
- )
- """)
- def test():
- start_time = time.time()
- crs.executemany("""
- INSERT INTO ##test (field_int, field_vc, field_dec) VALUES (?, ?, ?)
- """, data)
- end_time = time.time()
- return end_time - start_time
- times = []
- for x in range(3):
- times.append(test())
- conn.close()
- return times
- print "ceODBC:", multi_insert(ceODBC)
- print "pyodbc:", multi_insert(pyodbc)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement