Using BUFFER while updating records possible?

1

Another question on the use of the BUFFER() statement. When looping on a view the use of BUFFER is very useful to improve speed. I never tried that for a loop over a table.

Now I am considering doing that while updating. Is possible to use the BUFFER statement on a loop over a table when each record is updated? Or is it necessary to retrieve a record individually when it is updated? I am a bit in doubt because fetching x records at once might have a conflict when updating each record separately. (The values for each record are different based on the read values so I cannot use a PROP:SQL).

And to make it more complex, can I combine this with a Logout/Commit to speed up things more?

BTW: The database is MS SQL.

Using BUFFER() on a loop over a file doesn't work?
2

Yes. You can update the record. BUFFER() has no impact on functionality. It is purely a balance between network traffic, memory and number of sql statements.

3

That is great, will speed up things. Thanks once again for explaining.