[AccessD] MySQL insert records

Gustav Brock Gustav at cactus.dk
Fri May 5 13:51:20 CDT 2006


Hi all

When inserting records by a pass-through query from Access, I've found that reading the records off a text file using 

  LOAD DATA INFILE 
    '../data/test.txt'
  INTO TABLE 
    tempload

into an empty non-indexed table runs at about 50,000 records per second even using very modest hardware.
This is way faster than any normal "Insert Into ... " I've tried.

However, it's a bit clumsy first to have to write the data to a file.
Any comments or suggestions?

/gustav




More information about the AccessD mailing list