Differences

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

Link to this comparison view

Both sides previous revision Previous revision
admin:features:geo:home [2011/01/24 15:26]
127.0.0.1 external edit
admin:features:geo:home [2011/03/25 15:50]
deb
Line 1: Line 1:
 ~~NOTOC~~ ~~NOTOC~~
 +
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
  
Line 15: 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.txt ยท Last modified: 2016/06/28 22:38 (external edit)