|
On Jun 13, 2019, at 5:24 PM, Vinay Gavankar <vinaygav@xxxxxxxxx> wrote:
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,bosses)
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
--
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
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.