>I was wondering if anyone had done any checking to see if buffering works faster than non-buffered remote views?
>
>My secenario is that I am updating a SQL server database via a modem, and it seemed to me that if I buffered my views, it would write all the changes when I issued tableupdate(). The delete commands take forever to process and the insert commands are slightly longer.
>


All views are buffered by their very nature. The only difference is between table and row buffered. With row buffering, any changes are commited every time the record pointer moves (silly, if you ask me). With Table buffering, changes are only written when you issue a TABLEUPDATE().