Not sure how long to wait when asking Studio to import a 9 million row text file.
I was able to load 2 million rows, and in that case when I hit "FINISH" it hour-glassed for a few minutes, then gave the window showing the progress until completion (about 10 minutes total).
But on the 9 million, I get that preliminary hour glass, and after 30 minutes it is still there.
And the message in the loading window is "Load Data Wizard (Not Responding)".
I'm not sure if this is normal, and I just need to wait an hour or two until the actual loading starts, or if there is some limitation, and I need to break the load into multiples, or maybe one format works better than another.
The file is .txt tab delimited, and only two varchar(40) columns.
Solved! Go to Solution.
OK, the "Transfer Progress View" just popped onto the screen, so apparently Studio does a preliminary scan of the txt file prior to starting loading, and during this preliminary scan it shows as "Not Responding". Now Studio is running again.