# Using BUFFER while updating records possible?

**URL:** <https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872>\
**Category:** uncategorized\
**Created:** [December 20, 2025, 12:52pm UTC](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872 "2025-12-20T12:52:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Koen](https://clarionhub.com/letter_avatar_proxy/v4/letter/k/a9a28c/32.png) [@Koen](https://clarionhub.com/u/Koen)\
**Post date:** [December 20, 2025, 12:52pm UTC](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872/1 "2025-12-20T12:52:19Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Bruce](https://clarionhub.com/letter_avatar_proxy/v4/letter/b/ccd318/32.png) [@Bruce](https://clarionhub.com/u/Bruce)\
**Post date:** [December 20, 2025, 6:31pm UTC](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872/2 "2025-12-20T18:31:05Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Koen](https://clarionhub.com/letter_avatar_proxy/v4/letter/k/a9a28c/32.png) [@Koen](https://clarionhub.com/u/Koen)\
**Post date:** [December 22, 2025, 4:09pm UTC](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872/3 "2025-12-22T16:09:39Z")

</div>

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