title: optimize pymssql code
body: <p>i am inserting records to sql server from python using pymssql. The database takes 2 milliseconds to execute a query, yet it insert 6 rows per second. The only problem is at code side. how to optimize following code or what is the fastest method to insert records.</p>
  
  <pre><code>def save(self):
      conn = pymssql.connect(host=dbHost, user=dbUser, 
                             password=dbPassword, database=dbName, as_dict=True)
      cur = conn.cursor()
  
      self.pageURL = self.pageURL.replace("'","''")
  
      query = "my query is there"               
      cur.execute(query)
  
      conn.commit() 
      conn.close()
  </code></pre>