MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my

Posted by asksuperuser on Stack Overflow See other posts from Stack Overflow or by asksuperuser
Published on 2010-05-09T10:09:46Z Indexed on 2010/05/09 10:18 UTC
Read the original article Hit count: 192

Filed under:
|

I am currently adding hundred of thousands of rows of data to a table first on a MS Access Table then on a MySQL Table.

I first tried with MS Access, it tooks less than 40 seconds. Then I tried exactly with the same source and with the same table structure to MySQL and it took 6 min and 40 seconds that is 1000% slower !!!

So is there a myth that a database server is more performant ?

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about mysql