Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remote views and databases
Hi,
I am working on an application with tables having millions of records. I intend to upsize the database to MSDE2000 that comes with VFP7.
My questions are:
1. Does the speed of data retrieval using a remote view depend on the speed of the underlying database? And if yes, which among SQL(MSDE2000), ORACLE and mySQL is the fastest to use when working with remote views?
2. Which is the fastest technology to access big volumes of remote data, remote views or SPT (SQL Passthrough Technology)?
Thanks in advance.
Peterson.
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