Re: Interesting Benchmarks -- SQL, RPG, Journaling, and Triggers

[Barbara Morris <bmorris@xxxxxxxxxx>]

Lim Hock-Chai wrote:
> This is probably a Barbara question.  I wonder if there is performance
> different between update with and without %fields()?

I haven't measured it, but I wouldn't expect much difference in 
performance with and without %fields.  %fields just reduces the movement 
of data from some of the program variables to the I/O buffer.  I suppose 
if there were some huge fields, or a large number of date fields, it 
might take a bit of time to move the fields to the I/O buffer, but 
normally I would expect it to be a tiny fraction of the "real" update 
operation.

An third possibility is to use a data structure result field for the 
update.  That would probably cost less than an ordinary update, but it 
might be more or less than an update with %FIELDS, depending on how many 
of the fields were specified in %FIELDS, and the nature of the fields.