Nalazite se na CroRIS probnoj okolini. Ovdje evidentirani podaci neće biti pohranjeni u Informacijskom sustavu znanosti RH. Ako je ovo greška, CroRIS produkcijskoj okolini moguće je pristupi putem poveznice www.croris.hr
izvor podataka: crosbi !

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

Šimenić, Kristijan ; Lukić, Ivica ; Köhler, Mirko Geolocation and Data Type Impact on SQL Query Execution Time Using Different Database Approaches // Proceedings of 38th International Convention MIPRO 2015 / Biljanović, Petar (ur.). Rijeka: Hrvatska udruga za informacijsku i komunikacijsku tehnologiju, elektroniku i mikroelektroniku - MIPRO, 2015. str. 1225-1228

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

Povezanost rada

Računarstvo