1.A statement is parsed and executed
each time its call sent to database. 2. A prepared statement may be parsed once and executed
repeatedly with different parameters.
There are four steps for the execution of query:
1. Query is parsed
2.Query is compiled.
3. Query is optimized.
4. Query is executed.
In case of statement, the above four steps are performed every time.
And in case of prepared statement the above three steps are
performed once.
Total Post:23
Points:1152. A prepared statement may be parsed once and executed repeatedly with different parameters.
There are four steps for the execution of query:
1. Query is parsed
2.Query is compiled.
3. Query is optimized.
4. Query is executed.
In case of statement, the above four steps are performed every time. And in case of prepared statement the above three steps are performed once.