MySQLdb slow on MySQL 5

timothy.williams at nvl.army.mil timothy.williams at nvl.army.mil
Thu Feb 23 12:39:54 EST 2006


Hi.

I have a Python program that parses a file and inserts records into a
database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my
parser runs *really* slow. Writing out to CSV files is fine, but when I
try to insert the same records in a MySQL5 database, it slows to a
crawl. Using MySQL 4.1 seems fine. The data seems to be inserted
correctly, it's just really slow.

Has anyone else noticed a similar problem using MySQL5 and MySQLdb?

Thanks.




More information about the Python-list mailing list