2026-05-14T18:44:18.961Z http://ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai

ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai:1:3111 2015-09-10T08:34:07Z 1

SQL query execution time between two Singidunum University locations 2015 http://ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai/record/1/3111 http://portal.synthesis.singidunum.ac.rs/paper/350 В. Јовановић V. Lazović N. Minić The paper presents the creation of SQL queries using mathematical functions that provide the distance between the two points in the shortest time and at a high degree of accuracy. The conducted survey found that one of the three most commonly used formulas for the analysis of the site achieved the highest accuracy. Elements of the formula were converted into PHP language and thereby determined which of the analysed formula gave the highest accuracy the distance between two points. Haversin formula, which is simple to use, and also showed satisfactory accuracy, has been translated into a SQL query where the query execution time was tested. In order to get the information about the location quickly, the query was expanded with a request to search for locations located in a predefined radius starting from the given coordinates. The results used to determine the most accurate location gained this way to may be used for the development of modern mobile phones applications. conferenceObject 624 628 http://dx.doi.org/10.15308/Synthesis-2015-624-628 Proceedings of International Scientific Conference of IT and Business-Related Research - SYNTHESIS 2015