Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views/Local views
Message
 
 
To
13/07/2000 14:36:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00391974
Message ID:
00392177
Views:
32
>I'm new to views and I would like to find out the following :
>
>I have a database called euc.dbc and I need to find out
>When to use Remote views v/s Local views on my VFP database.

If you want your app to be scalable to high-end databases, use Remote Views with the assumption that you manipulate data using ANSI SQL.

>The .exe and the database(euc.dbc) is going to be located on a server.Users from remote locations will be accessing this application.
>Some forms will be using tables from this euc.dbc and I was thinking that the application would be faster if I use views instead of tables.

Using traditional approach of manipulating data in VFP is still faster than using VIEWS. But, if you are thinking of scalability and C/S approach, then use views.

View is just one of the several mechanisms available to manipulate data whether VFP data or from any server based databases. Look also into SQL Pass Through, ADO, Store Procedures, etc.

Local Views is directly connecting to VFP database table without using ODBC. Use ODBC, then your View becomes Remote.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform