MyDAC speed

[Napo]

I tried to transfer some BDE table to MySQL database using Delphi 2007 and MyDAC.
I had some problem of speed so I wrote two simple test apps that write 1000 record on a table composed of a single integer field (key).
The first application write to a MySQL table contained in a brand new DB schema.
The second write to a Paradox table using BDE.


Writing to MySQL database needs 12-15 seconds.
Writing to BDE needs less than 1 second, I cannot be precise but this is not important.
What is important to me is understand if MySQL application have some problem or if this lack of speed is a normal behavior.

MySQL server on localhost.
MyDAC 5.20.1.12
Athlon 64 X2 3800
Delphi 2007

Thanks

[Napo]

Update:

I moved from 1000 to 100000 records and changed engine from InnoDB to MyISAM.

Now MyDAC wrote all records in 15 secs, BDE in 25 secs.

[eduardosic]

Update:

I moved from 1000 to 100000 records and changed engine from InnoDB to MyISAM.

Now MyDAC wrote all records in 15 secs, BDE in 25 secs.

using innodb try


MyConnection.StartTransaction;

insert....
insert....
insert....
insert....

MyConnection.Commit;

is very Fast.