title: Bulk update SQL Server and Python
body: <p>I have the following issues, i am selecting 17K records from Azure SQL server database into a list with Python, preforming text manipulation and i want to update the result into the database , i have two fields record_id and Supplier name , i added all the updates into a new list and trying to update the database ,the issue is that the last part(for rec_to_update in sqlupdates) takes a lot of time more than 15 minutes :</p>
  
  <p>sqlupdates is the list of updates i want to preform ,  what am i doing wrong?</p>
  
  <pre><code>for record in Allrecords :
          Rec=re.sub(r'[^a-z]', ' ', record[1])
          querywords =Rec.split()
          resultwords  = [word for word in querywords if word.lower() not in List_of_words]
          result = ' '.join(resultwords)
          sqlupdates.append("Update labs_work_data_test set Supplier_Name='"+result+"' where record_id="+str(record[0])+";")    
      for rec_to_update in sqlupdates:
          newcursor.execute(rec_to_update)
  
      newcursor.commit()
  </code></pre>