Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do prepared statements offer better performance?

user-image
Question added by Afsheen Atif
Date Posted: 2014/06/13
Afsheen Atif
by Afsheen Atif

In the normal course, every time an SQL statement is executed on the database server,

the server must parse the SQL code and check its syntax and structure before allowing

it to execute. With a prepared statement, the SQL statement is stored in a temporary

location on the database server and thus only needs to be parsed and validated once.

Further, every time the statement is executed, only the placeholder values need to be

transmitted to the server instead of the complete statement.

Source:

PHP A Beginner’s  Guide

Vikram Vaswani

Cheers!

dear sir u 

     salam where are you told me then what are you do job dubai ?? 

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

As it avoid repeated traffic on DB server that way it helps improve better performance

Deleted user
by Deleted user

How About the uses of stored procedure and triggers and View??

More Questions Like This