Advertisement
johnmudd

Postgres individual inserts slow performance

Apr 13th, 2013
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.62 KB | None | 0 0
  1. #! /usr/bin/env python
  2.  
  3. import psycopg2
  4. import time
  5.  
  6. conn = psycopg2.connect('dbname=refillrx')
  7. cur = conn.cursor()
  8.  
  9. cur.execute('DROP TABLE header')
  10. cur.execute(' CREATE TABLE header( phone CHAR(10) )')
  11.  
  12. for i in range(8):
  13.  
  14.     t1 = time.time()
  15.     cur.execute("INSERT INTO header(phone) VALUES('1112223333')")
  16.     conn.commit()
  17.     print 'Elapsed: %.4f sec' % (time.time() - t1)
  18.  
  19.     time.sleep(0.2)  # Sleep 0.2 sec
  20.  
  21. '''
  22. Output:
  23.  
  24. Elapsed: 0.0116 sec
  25. Elapsed: 0.2018 sec
  26. Elapsed: 0.1982 sec
  27. Elapsed: 0.0019 sec
  28. Elapsed: 0.0030 sec
  29. Elapsed: 0.1945 sec
  30. Elapsed: 0.0017 sec
  31. Elapsed: 0.0013 sec
  32.  
  33. '''
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement