Whenever I read a file I read the complete file into an array so I can loop through the whole file (via the array). When I use split, someone recommended I use //, like this:

@file = <MYFILE>;
foreach $l (@file)
    {
    @colarray = split /,/, $l;
    }

The biggest file I have read this way was 500,000 lines, with no problems.