in reply to Re^2: What is the best approach to check if a position falls within a target range?
in thread What is the best approach to check if a position falls within a target range?

the query file contains some 2 million records and the target region has about 200,000 records.

Could you post 3 query file records and 3 target region records?

  • Comment on Re^3: What is the best approach to check if a position falls within a target range?

Replies are listed 'Best First'.
Re^4: What is the best approach to check if a position falls within a target range?
by umasuresh (Hermit) on Feb 12, 2011 at 14:26 UTC
    Hi BrowserUk,
    query ===== 100 200 300 target_region ============= 10_50 60_150 180_250 expected output =============== 100 60_150 200 180_250
    Thanks Much, Uma

      What are the min and max of these numbers? What are the typical and maximum spans of the regions?


      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 range can be anywhere from 200 to 300 or more. There is no defined min and max.