On 27/07/2009 09:10, Jamie Lawrence-Jenner wrote: > Apart from saving on the overhead of having to open up 5 separate > connections, what are the benefits to passing in multiple updates in one > statement?
If you do them all within one transaction - begin; update.... update... ... commit; - then you save on the overhead associated with beginning and committing a transaction for each update. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
