0
python script slowing the data load to a database

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


Python 23-10-20, 6:04 p.m. samrtr

Log-in to answer to this question.