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
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------