If you really want to optimize for speed, your situation of reading a long text file and parsing it is very similar to the 1BRC: Xojo1BRC (Xojo One Billion Row Challenge)
You could adopt some of those techniques.
2 Likes