Daniel Bowett wrote: > Daniel Bowett wrote: >> 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. >> >> > > UPDATE > ------ > > I have found the "executemany" function! It now takes around a second to > complete the 3000 inserts. > > Lesson learnt - I should have posted my code... > > Thanks for your help everyone.
Hi Daniel, I was just wondering the executemany sends the insert as batch, does it? That is what I was going to suggest for speed MySQL should process this very quickly as a batch the problem was probably getting them there. Regards, George -- http://mail.python.org/mailman/listinfo/python-list