Simon Willison’s Weblog

Subscribe

Python Django load MySQL database from csv files performance issue?

12th February 2012

My answer to Python Django load MySQL database from csv files performance issue? on Quora

Don’t use the Django ORM for bulk imports—the performance overhead is pretty small for regular web page stuff, but it adds up if you are running millions of inserts.

Either write your import code to call MySQLdb directly or use the mysqlimport command line tool.

This is Python Django load MySQL database from csv files performance issue? by Simon Willison, posted on 12th February 2012.

Next: How can I see what questions I am following on Quora?

Previous: How can you build a search engine for a website built in PHP/MySQL?

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe