This may seem dumb but yeah i want a efficient way to do this. Am using php right now and guy it's slow.

Any pointers please.


Anytime I must place massive levels of data, I use "LOAD DATA INFILE":

The bottleneck may be the indexing from the data. I would suggest crippling indexing just before running the burden data infile after which enabling it after.

I love HediSQL I've moved databases with more than millions of rows utilizing it. There's an import an export feature that actually works very well. It is a great mysql client and makes dealing with mysql much simpler than using phpMyAdmin.

One factor to test is removing any indexes before you decide to perform the place. After you have placed everything produce the indexes again.

MySql really has an excellent article about this along with other techniques. Have a look in internet marketing here.