Database »

1
Vote
Dealing with massive amounts of data in MySQL, one of the first lessons you are taught is -

-- Use LOAD DATA for quickly inserting lots of records into a table
-- Avoid multiple Inserts.

From MySQL documentation "The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed".
Posted by andyg 1503 days ago (http://www.softwareprojects.com)
Discuss  | |  Bury | Tweet This | Tagged: mysql load data Add To 
Read the full article

Who Voted for this Story

  1. Avatar andyg

Comments

No one has commented on this article yet.

Log in to comment or register here.