Re: Quotes in querys

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






It is over head, but it caches the execution plan for multiple runs of the
script. So different users with different data will use the same cached
query on the database. Saving processing time. It also prevents SQL
injection on the fly because you are indicating what data type each place
holder will need to accept.

No, it's per session.

http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html

The scope of a prepared statement is the client session within which it is created. Other clients cannot see it.


Well he probably meant that the mysql server will cache the query and that is true. But I think that mysql uses the cache only if the query is the exact same...

So it does no good in this case.

--
Thodoris


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux