MySQLdb

Daniel Bowett daniel at bowettsolutions.com
Tue Jan 25 15:43:54 EST 2005


I have just started playing around with MySQLdb for a project I am planning.

As a test I have written a script that executes 3000 insert statements 
on a table. The table contains 10 fields with a mix of text and numbers 
- its a product table for a website eg UPC, ProductName, Price etc.

The problem I have is that it takes just over two minuted to execute the 
3000 insert statements which seems really slow! I am running it on a 
machine with a 1.5 Ghz Pentium M Processor and Gig Of Ram. I dont think 
the machine is to blame for the speed because during execution the 
processor sits at about 10% and there is loads of free RAM.

Does anyone know if this sort of speed sounds right?

Cheers,

Dan.





More information about the Python-list mailing list