I am working on a new system which I think I am gonna have to use views.
I have a Windows NT server using Visual FoxPro as a backend WWW server. This is mainly the same installation I have presently for the Universal Thread. But, part of this system will get its tables from another server in another location. We use the Windows NT built in share connection to map a drive to this secondary server.
Lets say that drive J: is mapped to this secondary server which is in another location. Both servers are connected to the Internet at ISDN high speed connection. So, for example I can say USE J:\DBFS\CLIENTS.DBF. This is however slower than if the file was located on my main server because I have to downgrade to 40 times less the actual speed of Ethernet.
However, I have found that by using views to access the data I need from J:\DBFS\CLIENTS.DBF was faster that using SELECT * FROM CLIENTS...
I never used views before and this seems to be the solution to go for this installation. Am I on the right track by using views?