Relative Content

Tag Archive for pythonmysqldatabase

Mysql database insertion delay through python

currently i am working on the python project that connects to mysql database using pymysql library of python. i have to insert around 5000 rows using stored procedure present in database.but for a single row insertion it is taking 1-2 seconds(via python code).below is this function(you can assume that connection has succesfully made)

Is this a correct way to manage a DB?

I’m writing a small app on python using Mysql DB.
Could you tell me please is this method is viable?
I’m just not sure if I should every time ask a DB for some data, knowing nothing has changed since the last call. This way I technically can reduce the excessive work, though it feels VERY wrong