title: MySql insert speed too slow
body: <p>I am working on a project which is receiving information from GitHub API and analyze them. The problem is when ı try to insert this kind of huge data (for example in files I insert a list of lists as seen below which has 19k item in it) it takes a very long time. How can I improve that? Thanks.</p>
  <pre><code>       for i in commits_array:
              for j in i[-1]:
                  self.insert_value_to_files_DB(j)
  
  
      def insert_value_to_files_DB(self, array):
      try:
  
          sql = &quot;INSERT INTO files (file_count,file_sha,file_name,file_status,file_additions,file_deletions,file_changes,commit_sha) VALUES (%s, %s, %s, %s,%s, %s, %s,%s)&quot;
          self.cursor.execute(sql, array)
          self.connection.commit()
      except mysql.connector.Error as error:
          print(&quot;Failed to insert into MySQL table {}&quot;.format(erro
  </code></pre>