General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only