Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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.
  
 ====  ==== ====  ====
 
Back to top
admin/features/geo/home.1294702956.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)