Topic: Search of minimum values

Council as is better to make is necessary.
In basis there are certain coordinates (width and a longitude). It is necessary to deduce 10 places nearest to any specified point.
Anything did not invent more cleverly, except how to be transversed on all basis and to calculate "diagonal" bringing in an array, and then to deduce 10 minimum values. I suspect, what on  sites it becomes not so, can someone prompts a method better?


Re: Search of minimum values

spatial index


Re: Search of minimum values

FAQ: Finding of records where the preset value is between field values