Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Questions about views
Message
 
À
19/01/1999 04:56:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00177502
Message ID:
00177517
Vues:
28
>1) Is it a problem (performance) to have a big number of views in a
> database?

Not really. How many do you propose to use? The more objects you have, the longer it will take to open the Database Designer...

>2) Is it useful to do all access to data via views, to keep the
> ability of using remote data in my application?

IMHO, views are better to use as a better separation in data is achived. However, I would not rely on remote views to access remote data. At the very least, I would not use the remote view as the basis for updating. Rather, I may use the view to display, but share the connection and use SQL Pass Through. Then again, based on pending improvements to the product, I would use ADO instead... But a combination of views and SPT is something you could implement today..
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform