MySQLdb

[George]

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