Import data tool speed

2 views (last 30 days)

Show older comments

Brad_EE on 11 Dec 2020

Commented: Yair Altman 2020年12月13日

Accepted Answer: Yair Altman

Platform: W10-64bit, 4 core, 500GB SSD, 32GB Ram

文件导入说明：80MB，包含逗号界数字和短字符数组。总体格式27列x 400k线。

Clicking the import data tool icon prompts for a file name, shows a message "Opening a large text file ..." and then displays the file contents in a table format on the GUI after ~5 seconds. The table displayed matches the file contents.

在同一GUI上，我将输出类型设置为单元格数组，并范围为A2：AA395201（整个文件减去标头线）。单击“导入选择”按钮显示消息“导入数据...”和一个状态栏，该状态栏在突然消失之前保持灰色35分钟。在那时，导入已完成，变量名出现在工作区中。

Why does the initial opening large text file finish in 5 seconds but the import take 35 minutes? It seems for the opening large text file step to complete and display the data in the GUI table, it has essentially imported the data but 500X faster!