pandas to_sql 插入过慢

def set_d_type_dict(df):

    type_dict = {}

    for i, j in zip(df.columns, df.dtypes):

        if "object" in str(j):

            type_dict.update({i: VARCHAR(512)})

        if "float" in str(j):

            type_dict.update({i: DECIMAL(19, 2)})

        if "int" in str(j):

            type_dict.update({i: DECIMAL(19)})

    return type_dict

d_type = set_d_type_dict(df)

df.to_sql('table_name', engine, if_exists='append', index=False, dtype=d_type)