This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:geo:home [2011/01/10 23:42] els |
admin:features:geo:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ~~NOTOC~~ | ||
+ | |||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
Line 5: | Line 7: | ||
===== Geographic Searches ===== | ===== Geographic Searches ===== | ||
- | **[[admin:features:geo:home|Overview]]** -> [[admin:features:geo:latlong|Latitude and Longitude]] -> [[admin:features:geo:radius|Radius Distance Searches]] -> [[admin:features:geo:indexing|Indexing]] -> [[admin:features:geo:optimization|Optimization]] | + | **[[admin:features:geo:home|Overview]]** | [[admin:features:geo:latlong|Latitude and Longitude]] | [[admin:features:geo:radius|Radius Distance Searches]] | [[admin:features:geo:indexing|Indexing]] | [[admin:features:geo:optimization|Optimization]] |
---- | ---- | ||
Line 14: | Line 16: | ||
To support these types of searches, Omnidex provides the capability to report and search based on distances from geographic coordinates. These searches are possible using some simple Omnidex indexes paired with a [[dev:sql:functions:distance|$DISTANCE function]] available in SQL SELECT statements. This function reports the distance between two sets of coordinates, and can also be used in criteria to select rows that meet distance requirements. | To support these types of searches, Omnidex provides the capability to report and search based on distances from geographic coordinates. These searches are possible using some simple Omnidex indexes paired with a [[dev:sql:functions:distance|$DISTANCE function]] available in SQL SELECT statements. This function reports the distance between two sets of coordinates, and can also be used in criteria to select rows that meet distance requirements. | ||
- | Current implementations of relational databases provide some support for distance calculations; however, these can be complex and costly. Some database requiring that the developer code trigonometric functions in stored procedures. Some databases do not use indexes to speed these searches. Some databases charge separately for this feature. Omnidex provides this capability in the base product. | + | Current implementations of relational databases provide some support for distance calculations; however, these can be complex and costly. Some databases require that the developer code trigonometric functions in stored procedures. Some databases do not use indexes to speed these searches. Some databases charge separately for this feature. Omnidex provides this capability in the base product. |
==== ==== | ==== ==== |