in reply to Alternative to querying a database to save time

I have around 58,00,000 primarykeys in FILE1

Is that 5.8 million or 58 million or ... ?

And how many rows are there in your table?

I am going to work on multiple such FILES.

Do you mean pairs of files?

Ie. will each new query consist of a different FILE1 & FILE2? Or the same FILE1 with a different FILE2? Or vice versa?

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.

The start of some sanity?
  • Comment on Re: Alternative to querying a database to save time

Replies are listed 'Best First'.
Re^2: Alternative to querying a database to save time
by choroba (Cardinal) on Dec 29, 2011 at 10:46 UTC
    Never heard about lakh? Or crore? Beautiful brain gymnastics.
[reply]

      I've encountered lakhs a couple of times, but I'd never seen a number written that way.

      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.

      The start of some sanity?
[reply]
        It's easy to switch, though. 10 years ago, I spent 1 month in India. After returning to Europe, I had to convert millions to lakhs and crores for the several first days to understand newspapers at home :-)
[reply]

In Section Seekers of Perl Wisdom