in reply to fastest way to compare numerical strings?

Let me suggest the non-perl solution: have your database do it for you. The magic phrase you need to tell Google seems to be "geodistance" and it yields the following interesting results:
  • Comment on Re: fastest way to compare numerical strings?

Replies are listed 'Best First'.
Re^2: fastest way to compare numerical strings?
by BrowserUk (Patriarch) on Jun 30, 2008 at 23:50 UTC

    If the OP will supply the data, I pretty much guarentee that this can be solved directly in Perl more quickly that you can load the data into MySql and add a "geospatial index", let alone construct & run the query, and then retrieve the results.

    And with less lines of code.


    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.
      True, but there's always the possibility that the data is already (or wants to be) in a database.

      I'm just throwing out other options.