Someone has idea how long time it will take to import?

I hear something like 40k each minute?


closed as too broad by ypercubeᵀᴹ, a_horse_with_no_name, Derek Downey, Paul White says GoFundMonica, RolandoMySQLDBA Apr 11 '14 at 14:36

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • How long is a piece of string? – Colin 't Hart Apr 11 '14 at 12:50
  • @Colin'tHart Mine's about 11 inches... – Mark Sinkinson Apr 11 '14 at 14:11

The only reliable way for you to find out yourself is to import a subset and extrapolate.

The answer to your question depends on too many parameters

  • how powerful is your machine?
  • does the data have to go through a bottleneck (connection speed, etc.)?
  • how large is your data in each row?
  • how big is the overhead from writing indices?
  • what method will you use to import your data?

Not the answer you're looking for? Browse other questions tagged or ask your own question.