Information générale
Titre:
Which is fastest? On a SQL Server or Oracle DB
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???
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement