Yes, thank you. All the suggestions were informative. I will considr them all, but I may end up using this one.
BTW - I am investigating the possibilities of using mapquest.com services. This way it menas no worries or maintenance on my part.
Henning Sittler
www.inscriber.com
-----Original Message-----
From: [Gauthier] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:08 PM
To: Multiple recipients of list witango-talk
Subject: Re: Witango-Talk: DB Searches - Nearby Countries
So a solution will be to store the computed result for each region with each
other existing region in another table or a memory array :)
Thanks for recommandation
Gauthier
----- Original Message -----
From: "Troy Sosamon" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 8:09 PM
Subject: RE: Witango-Talk: DB Searches - Nearby Countries
> If you have a large data set, this method has a lot of overhead becuase
you
> have to compute the distances for every row.
>
> Troy Sosamon
>
> -------------- Original Message
> Put the (x,y) co-ordinates in the DB along with the location name.
Latitudes
> and longitudes could work. Then show everything with a radius of N
degrees,
> or show the M closest entries:
>
> If I recall,
> Distance=((x2-x1)^2 + (y2-y1)^2)^(.5)
>
> Of course, the actual distance will only be approximate for longitudes...
>
