Heyho! On Monday 31 May 2010 04.18:04 Dennis Gearon wrote: > One thing, can prepared statements be done, including the 'execute', > inside of a transaction, and what are the side effects? Semantically, the statement is exactly like a "not prepared" statement: it happens at execute time, the rest (prepare, variable binding) happens independently of the transaction as far as I know. Performance: there may be slight differencies since prepared statements will cache the query plan. Unless you have relatively complex queries where the execution plan depends heavily on the actual values to be bound to the prepared statement this shouldn't matter much, though. (Somebody please correct me if I'm wrong, I'm not a pg pro :-) cheers -- vbi -- Today is Sweetmorn, the 5th day of Confusion in the YOLD 3176 Celebrate Syaday
Attachment:
signature.asc
Description: This is a digitally signed message part.
