http://www.perlmonks.org?node_id=1031059


in reply to Re: Reading HUGE file multiple times
in thread Reading HUGE file multiple times

Hi there,

Thanks for the tips. My data looks something like

>ID

Data (a verrry long string of varying length in a single line)

>ID again

Data again

Indexing might be a good idea. Maybe I could only read the IDs (skipping the next line) and then when accessing just add +1 to the index? I need to extract them twice in a code in different subroutines and each time the subroutine specifies what to do with them. I don't know if it is a good idea to store it all in a hash. I only need to extract a fragment of the data in first read and the whole data entry in the other. I don't have the IDs in advance, the suroutine specifies which one I need and what to do with it. I've tried

$Library_Index{<$Library>} = tell(ARGV), scalar <$Library> until eof();

but it takes very long time to do. I wonder if there is a better way to do it since this would be a bottleneck.

Replies are listed 'Best First'.
Re^3: Reading HUGE file multiple times
by BrowserUk (Patriarch) on Apr 28, 2013 at 13:30 UTC
    I've tried $Library_Index{<$Library>} = tell(ARGV), scalar <$Library> until eof();but it takes very long time to do.

    How long?

    I wonder if there is a better way to do it since this would be a bottleneck.

    If you are re-using the file many times you could construct the index and write it to a separate file. It should be substantially quicker to read the index from a file than to construct it from scratch each time.

    With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.
[reply]
[d/l]
      It's over 10 min so I kill the process. I think the reason is it's writing data line as a hash name and the data line can have 300.000 characters. I changed it so it only reads the index of the ID and then will just add 1 to it when I need the data. Then it's done in couple of seconds. Thanks for the tips with the index.
[reply]
        I think the reason is it's writing data line as a hash name and the data line can have 300.000 characters.

        No, it's not.

        At least, if your description of the file is accurate it isn't.

        This bit of the code: $Library_Index{<$Library>} = tell(ARGV), reads the IDs and constructs the hash.

        And this bit: scalar <$Library> reads and discards the long data lines.

        However, Now I think I see the problem with your version of the code.

        This bit:until eof(); of the line iterates until the file is read, except that you forgot to put the filehandle $Library in the parens, so the program will never end because it is testing the end-of-file condition of a different file which will never be true.

        Change the line to:

        $Library_Index{<$Library>} = tell(ARGV), scalar <$Library> until eof($
+Library);

        [download]

        And see how long it takes.

        With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
        Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
        "Science is about questioning the status quo. Questioning authority".
        In the absence of evidence, opinion is indistinguishable from prejudice.
[reply]
[d/l]
[select]

      I tried the new code and it works really fast. Problem is there is an error with tell and it's all -1. From Dumper 

      $VAR32564 = -1;
$VAR32565 = '>ENST00400413799
';

      [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom