Performance analysis of SQL Prepared Statements in CRUD operations

Abstract

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.