Hi Wayne,
Thanks for your reply. The main reason for my moving the data into MSDE is is mostly to do with security. My users already know how to manipulate DBFs and this is what I want to avoid.
What would be your advice to me regarding how I move from DBFs into a bigger secure database.

Thanks again for yor reply.

---------------------------

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

I would not consider that to be much of an 'upsize'. You could experience speed problems moving from fox to msde. How big are the files that make up the vfp db? If they do not approach the 2gb limit, I would stay where I was.

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

The speed of data retrieval depends on your design and how you pull the data back to the client. If you properly index the tables, and place limits on what is retrieved, speed can be lightning fast. But if you pull enourmous amounts of data all the time, then it will be slow. It has to be.

It is not a fair comparison - SQL(MSDE2000) and mySQL are not in the same league as Oracle.

>
>2. Which is the fastest technology to access big volumes of remote data, remote views or SPT (SQL Passthrough Technology)?
>

Neither will be fast if you pull back a lot of data at one time. And it depends on what you mean by 'fast'. If you work with data locally a lot, then your network bandwidth will come more into play. If however you do large transactions on the server, you need more horsepower on the server.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated