Rerunning with 5.16 yielded a runtime of 60 seconds.
Conclusion: With 384GB of ram; your (relatively) tiny 10e6 lines test file is being read from system file cache, hence effectively disguising the disk IO costs.
If your 80GB file fits in cache and will always be there when you need to do this; you can ignore the effects of disk.
Otherwise ... you need to re-run all your testing using the real file and having flushed the cache before each test.
In reply to Re^9: selecting columns from a tab-separated-values file
by BrowserUk
in thread selecting columns from a tab-separated-values file
by ibm1620
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |