Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql = "INSERT INTO #tmp (txt) VALUES (?)"
- batchsize = 10
- rows = []
- for row in df.itertuples(index=False):
- rows.append(row)
- if len(rows) % batchsize == 0:
- crsr.executemany(sql, rows)
- rows = []
- if len(rows) > 0:
- crsr.executemany(sql, rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement