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
- Notes from Bing Chat—Our First Encounter With Manipulative AI - 19th November 2024
- Project: Civic Band - scraping and searching PDF meeting minutes from hundreds of municipalities - 16th November 2024
- Qwen2.5-Coder-32B is an LLM that can code well that runs on my Mac - 12th November 2024