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???