Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote Views/Local views
Message
 
À
13/07/2000 14:36:11
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00391974
Message ID:
00392177
Vues:
33
>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."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform