Slow INSERT SQL

[bowettwow]

I have a python script that is inserting about 7000 records (each with 15 fields of 25 chars or less) into a DBF.

Each SQL statement is stored as a String in a list. I loop through the list executing each statment as I go. The problem I have is it seems to be running slowly. It takes approximately 10 minutes to run the whole thing.

Is there any way I can speed up this process???

 

[bowettwow]

Update:

I have tried writing it to an Access Table and it runs about 10 times faster. I'm therefore guessing that DBASE isn't the best way to go when doing these sorts of operations.

Any speed suggestions would still be appreciated.

 

[ericbrunson]

Put it in MySQL?

That's about the best suggestion I can make, it isn't a Python speed problem, it's a problem with your database.

 

[bowettwow]

eric,

Thanks for the suggestion. I knew there was a speed difference between databases but wasn't aware the difference was so vast. I guess this is a good demonstration...

Cheers.