Re: Partial record update - any performance advantage?

Thanks everyone. The advantages of partial updates are understood, but
someone claimed that it gives a better performance, hence I just wanted to
either verify or debunk that statement.

On Thu, Jun 13, 2019 at 2:53 PM Booth Martin <booth@xxxxxxxxxxxx> wrote:

Performance isn't the real issue, imho. Its more about updating &
record locks. If someone else is in there changing f5 through f100
while your user is updating f1 through f4 then that other user is going
to be scratching her/his head as to why update don't work. And the
other way around, too.

On 6/13/2019 8:18 AM, Vinay Gavankar wrote:

Hi,

If I have a table with 100 fields, when updating only 4 fields, is there
any performance advantage of using

update rcdfmt %fields(f1, f2, f3, f4);
vs.
update rcdfmt;

Is the advantage (or absence) documented anywhere (need to show my

bosses)

Thanks
Vinay

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com