It seems that you want to search for exact matches columns. If you know all the things you are looking for before hand, I would create a hash with the items you are searching for. So for instance if you are looking for 1101077781160, 1101077783669, and 1101077781182, I'd start off with 
my %queries;
$queries{$_} = 1 for qw(1101077781160 1101077783669 1101077781182);

[download]
Then I'd iterate over the file, split each line into fields, and test each field against the hash previously build.

This avoid multiple passes over the file (as you would with grep), or loading in the entire file into a hash.

And if I only looking for a single entry, perl script will still load everything into memory before it could look for the string I want?
You tell us instead of asking! You wrote the code. If you wrote your code it first slurps in the entire file, then the answer is yes. If you wrote your code it didn't, then the answer is no.

In reply to Re: Rapid text searches by JavaFan
in thread Rapid text searches by joomanji

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.