title: Importing 70MB csv file taking around 70 hours in mysql?
body: <p>I am trying to import a csv file (space separated if that makes any difference) of 70MB
  which consists of about 6 million lines , each line contains 2 numbers (2 columns).</p>
  
  <p>It is taking approximately 1 hour to import 1 MB of file, which has around million lines.
  I tried using the Import feature of phpmyadmin (CSV), and also tried using Bigdump but both are almost taking the same time. </p>
  
  <p>My worry is how can a simple 70 MB file take such a long time (2 and half days) to load into a database? then, what is the point of using a database if importing itself takes so long ?</p>
  
  <p>I put the max_memory_size = 1280 MB, so I don't think there is any memory problem for a 70mb file. I am doing it on my localhost, I also tried on my department's server. it is taking the same amount of time even when using bigdump.php and there are no internet speed problems</p>