Naslov
Performance analysis of SQL Prepared Statements in CRUD operations

Autori
Seser, Tomislav ; Pleština, Vladimir ; Marjanica, Frane

Vrsta, podvrsta i kategorija rada
Radovi u zbornicima skupova, cjeloviti rad (in extenso), stručni

Izvornik
SpliTech 2022: 7th International Conference on Smart and Sustainable Technologies: Proceedings / Šolić, Petar ... [et al.] - Split : Fakultet elektrotehnike, strojarstva i brodogradnje Sveučilišta u Splitu, 2022, 1-5

ISBN
978-953-290-116-0

Skup
7th International Conference on Smart and Sustainable Technologies, SpliTech 2022

Mjesto i datum
Online ; Bol, Hrvatska ; Split, Hrvatska, 05.07.2022. - 08.07.2022

Vrsta sudjelovanja
Predavanje

Vrsta recenzije
Međunarodna recenzija

Ključne riječi
prepared statements ; database optimization ; SQL ; CRUD operations

Sažetak
In a web application, communication between the application and the database server is one of the most resource intensive operations which therefore requires optimization. Database optimization is a challenging task where even a minor change can have a big impact on overall application performance. Prepared statements bring two main advantages: security and consistency. They are often considered to also have a performance advantage but, in this paper, it will be shown how prepared statements can have decremental performance impact, and when they should and should not be used if resources and performance is a concern.

Izvorni jezik
Engleski

Znanstvena područja
Elektrotehnika, Računarstvo, Informacijske i komunikacijske znanosti

POVEZANOST RADA