ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How do prepared statements offer better performance?

user-image
تم إضافة السؤال من قبل Afsheen Atif
تاريخ النشر: 2014/06/13
Afsheen Atif
من قبل 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!

rehman akram
من قبل rehman akram

dear sir u 

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

Gayasuddin Mohammed
من قبل 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

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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

المزيد من الأسئلة المماثلة