>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.
Hi Jess,
Both of them work on the same concept. The remote view is much easier to maintain as you have a visual interface. Though you might end up using a mixture of both depending on your requirements.
>1 million records takes 2 minutes to update the back-end table. It's >ridiculous.....
This statement is slightly confusing. Are you trying to update 1 million records at a time? or is it that you have a table with 1 million records and you are updating just couple of records?