Opened by pug at 2006-01-20 15:37
[quote=nepos,22.01.2006, 16:28]Gerade bei Postgres bringt dir prepare+execute keine Vorteile in der Geschwindigkeit. Aber das nur am Rande :)[/quote]
Aus PG 8.0.3 Documentation:
PREPARE
Name
PREPARE -- prepare a statement for execution
PREPARE creates a prepared statement. A prepared statement is a server-side object that can be used to optimize performance. When the PREPARE statement is executed, the specified statement is parsed, rewritten, and planned. When an EXECUTE command is subsequently issued, the prepared statement need only be executed. Thus, the parsing, rewriting, and planning stages are only performed once, instead of every time the statement is executed.
Ch.Lamprecht
Aus PG 8.0.3 Documentation:
PREPARE
Name
PREPARE -- prepare a statement for execution
PREPARE creates a prepared statement. A prepared statement is a server-side object that can be used to optimize performance. When the PREPARE statement is executed, the specified statement is parsed, rewritten, and planned. When an EXECUTE command is subsequently issued, the prepared statement need only be executed. Thus, the parsing, rewriting, and planning stages are only performed once, instead of every time the statement is executed.
Ch.Lamprecht