>I've been using remote views primarily. I can use SQL Pass-thru and I do for executing stored procedures on MS-SQL Server. So what's the advantage of a remote view that SELECT * FROM TABLE over an SPT that does the same command?
>
>Is updating tables using SPT faster than updating using remote views?
>
>How does optimistic/pessimistic buffering affect performance in updating large #'s of records?
>
>Is there a set of guidelines to follow in determining which approach to take per scenario?
Personally, I think using views is more efficient than SPT for updating a lot of records. Plus you do not have to code all the updates as you do with SPT.
If I only need to change data in a small number of records and can accomplish with 1 SQL command [based on the WHERE clause], I will use SPT.
As for buffering, views can only be optimistically buffered. Usually I use table buffering.
Mark McCasland
Midlothian, TX USA