Почему функция dataframe.to_sql работает очень медленно?
Прилагается код на Python:
@app.route("/conn/<db_file>")
def create_connection(db_file):
""" create a database connection to the SQLite database
specified by db_file
:param db_file: database file
:return: Connection object or None
"""
conn = None
try:
conn = sqlite3.connect(db_file)
except Error as e:
print(e)
return conn
def run(conn,sql):
cur = conn.cursor()
cur.execute(sql)
conn.commit()
@app.route("/sql")
def create_project():
"""
Create a new project into the projects table
:param conn:
:param project:
:return: project id
"""
t=str('a')+str(int(datetime.now().timestamp()))
conn=create_connection("c:\\users\\user1\\desktop\\data.db")
run(conn,f'''
CREATE TABLE '''+
t+''' (
"host" TEXT,
"count" INTEGER,
PRIMARY KEY("host")
);
''')
sql = mos1("1").to_sql(str(t),con=conn)
cur = conn.cursor()
cur.execute(sql)
conn.commit()
return sql
С уважением,
Натаниэль