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.
More recent articles
- Reverse engineering some updates to Claude - 31st July 2025
- Trying out Qwen3 Coder Flash using LM Studio and Open WebUI and LLM - 31st July 2025
- My 2.5 year old laptop can write Space Invaders in JavaScript now, using GLM-4.5 Air and MLX - 29th July 2025