Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches (CROSBI ID 625847)
Prilog sa skupa u zborniku | izvorni znanstveni rad | međunarodna recenzija
Podaci o odgovornosti
Šimenić, Kristijan ; Lukić, Ivica ; Köhler, Mirko
engleski
Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches
Picking right database approach or connection – Application Programming Interface in PHP used to achieve connection to database server, together with database and table definition affects query execution time. Servers are located in different geographical positions affecting roundtrip time (RTT). Four different database connections are used together with queries consisted of same data trying to point time difference using PHP and MySQL database server. Most common data structures are tested both for time difference and needed storage space. Combining data types and choosing a good database connection in terms of simplicity, security and time needed for execution, lead towards saving space and time. Time and storage problems often occurs when operating with large amount of data which will be case in this paper. Also, providing facts and results, best database connection and table optimization in default database configuration are given. Later optimization can be achieved in terms of choosing different database engines for specific needs.
Database; query execution; optimisation; round-trip time; geolocation
Rad sa studentom
nije evidentirano
nije evidentirano
nije evidentirano
nije evidentirano
nije evidentirano
Podaci o prilogu
1225-1228.
2015.
objavljeno
Podaci o matičnoj publikaciji
Proceedings of 38th International Convention MIPRO 2015
Biljanović, Petar
Rijeka: Hrvatska udruga za informacijsku i komunikacijsku tehnologiju, elektroniku i mikroelektroniku - MIPRO
978-953-233-083-0
Podaci o skupu
38th international convention on information and communication technology, electronics and microelectronics
predavanje
25.05.2015-29.05.2015
Opatija, Hrvatska