Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
how to insert data quickly into mysql table

Subject: how to insert data quickly into mysql table

From: hailiang shen

Date: 1 Feb, 2010 15:55:22

Message: 1 of 1

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

Tags for this Thread

No tags are associated with this thread.

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us