PDO - Prepared Statement bei einfachem SELECT

**AmicaNoctis** · 18-02-2010, 20:22

Hallo,

ja, aber nur, wenn du dasselbe Statement (auch mit unterschiedlichen Parametern) mehrmals benutzt. Andere Vorteile von PS sind z. B. das automatische Escaping.

Gruß,

Amica

**Paloran** · 21-02-2010, 14:34

ist es bei einmaliger Benutzung langsamer?

**AmicaNoctis** · 21-02-2010, 15:59

Meistens.

Originally posted by http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html

Sometimes prepared statements can actually be slower than regular queries. The reason for this is that there are two round-trips to the server, which can slow down simple queries that are only executed a single time. In cases like that, one has to decide if it is worth trading off the performance impact of this extra round-trip in order to gain the security benefits of using prepared statements.

**Paloran** · 22-02-2010, 17:10

Danke

PDO - Prepared Statement bei einfachem SELECT