Advertisement
Guest User

pyodbc vs ceODBC executemany performance

a guest
Mar 31st, 2010
1,904
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1. import time
  2.  
  3. import ceODBC
  4. import pyodbc
  5.  
  6. dsn = "<insert your dsn here>"
  7.  
  8. data = 1000 * [(1, "testing", 5555.5555)]
  9.  
  10. def multi_insert(odbc):
  11.  
  12.     conn = odbc.connect(dsn)
  13.     crs = conn.cursor()
  14.  
  15.     crs.execute("""
  16.    CREATE TABLE ##test (
  17.        field_int int,
  18.        field_vc varchar(50),
  19.        field_dec decimal(10, 5)
  20.    )
  21.    """)
  22.  
  23.     def test():
  24.         start_time = time.time()
  25.         crs.executemany("""
  26.        INSERT INTO ##test (field_int, field_vc, field_dec) VALUES (?, ?, ?)
  27.        """, data)
  28.         end_time = time.time()
  29.         return end_time - start_time
  30.  
  31.     times = []
  32.  
  33.     for x in range(3):
  34.         times.append(test())
  35.  
  36.     conn.close()
  37.  
  38.     return times
  39.  
  40. print "ceODBC:", multi_insert(ceODBC)
  41. print "pyodbc:", multi_insert(pyodbc)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement