SQLEXEC() to a stored procedure is probably fastest. However, all of these methods should be extremely fast with these small tables and selects by the primary key (I assume all of your mainkeys are indexed).
>I am trying to implement an Oracle and SQL server backend for our
>Visual Foxpro app.
>It does Mainly straight selects where tables are up to 1000-3000
>records no more probably less ...
>Each Table has a mainkey field so
>all queries would be of type select * where mainkey='bshjshj'
>
>Which method will have the best performance?
>1)SQL pass through
>2)Remote Views
>3)SQLEXEC() to a stored procedure.
>
>Also anyone got any tips???