python script slowing the data load to a database

samrtr
hi I am trying to load data to a database (mysql and sqlserver) using insert sql scripts in python cur.execute(query,(data list)) , after inserting 100 mb volume of data the loading process is slowing down each record 7 min approximatley after 100mb data . am running the python code in linux redhat 8 .how can i optimise this so that it runs the same as first 100 mb data

env : linux ram : 8 gb instance type : t2 medium python 3.8
Tagged:
Sign In or Register to comment.