Re: is single row update improved with function

2017-12-31 Thread Rob Sargent
> On Dec 31, 2017, at 4:31 PM, David Rowley > wrote: > > On 1 January 2018 at 12:06, Rob Sargent wrote: >> I must update 3M of 100M records, with tuple specific modifications. I can >> generate the necessary sql, but I’m wondering if files of simple update >> statements affecting a single r

Re: is single row update improved with function

2017-12-31 Thread Rob Sargent
> On Dec 31, 2017, at 4:31 PM, David Rowley > wrote: > > On 1 January 2018 at 12:06, Rob Sargent wrote: >> I must update 3M of 100M records, with tuple specific modifications. I can >> generate the necessary sql, but I’m wondering if files of simple update >> statements affecting a single r

Re: is single row update improved with function

2017-12-31 Thread David Rowley
On 1 January 2018 at 12:06, Rob Sargent wrote: > I must update 3M of 100M records, with tuple specific modifications. I can > generate the necessary sql, but I’m wondering if files of simple update > statements affecting a single row is more effective than files of a function > call doing the