Thread Subject:

how to insert data quickly into mysql table

Dear all,
I am trying to trasfer data in text file into mysql database table by matlab database toolbox.

I have 1 204 709 records in my text file. The data can be loaded into matlab workspace very quickly with textscan function, however, the speed is very slow with fastinsert function, which takes 1920 seconds, or 0.53 hrs.

Is there any other faster way to significantly reduce the runtime?

Thanks,
Hailiang