MySQL very slow compared to MS Access when inserting hundred of thousands of rows ! So is there a my
- by asksuperuser
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 ?