Remote views are slow. Pass through cursors are fast - but there is some code overhead to manage database updates. Parametrized should speed either up - but you'll get a better approximation of rushmore by using pass through.


>Hi all, I am trying to migrate data an app to sqlserver, also have made test with progress rdbms, but there is a customer table with aprox 52,000 records, I am building a parametrized view to access sqlserver data for column name (i have an index in sqlserver for that column) but even with that it takes some time to retrieve data, far more that with vfp, also have tried select * from customer where cust_id="100022" (direct to pk) but feel it kind of slow.
>
>What this because I was used to vfp perfomance ?, I have made similar tasks with MYSQL backend with fast response also.
>
>Thanks for any feedback
>
>
>Norman