2 ms·

DataFrame.to_sql() seems painfully slow, do you have any tips for speeding it up? What I do is dump it as CSV again after manipulation and then bulk load it in

by gaius 9y ago

DataFrame.to_sql() seems painfully slow, do you have any tips for speeding it up? What I do is dump it as CSV again after manipulation and then bulk load it into the DB using the DB's native tool. It's messy but 10x faster.