Jess,
SQL pass-through will often be faster, but it shouldn't be that much faster. You may want to take a look at the back end and try to figure out exactly what commands are being sent. Does it take as long to update a record using SQL pass-through? Is there an index on the key field you're using to do your update? If you're using SQL Server, have you run UPDATE STATISTICS on the table you are updating recently? What's the back-end?
I generally use views to update data and pass-through to run queries. I like pass-through because it's easier to create queries on the fly, but I like the convenience of having FoxPro handle updates for me with a view. When you come right down to it, the remote view usually results in the same command going to the back end that I would send with pass-through. This means the performance is identical. I highly recommend tracing the commands the back-end is receiving. You may find something you didn't expect.
>Hi all!
>
>Which is superior, Remote View or SQL pass-through? A clear definition of the specific Role of said features will be highly appreciated. We are having problem in using view to update the source table. 1 million records takes 2 minutes to update the back-end table. It's ridiculous.....