Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Few Questions About Remote Views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00637585
Message ID:
00637645
Vues:
20
Let me take these questions out of order, they'll make more sense that way.

>2) What are the decision criteria for using a local/remote view.

If you are using native VFP tables, use local views. If you are using some other data store (eg. SQL Server, SQL Anywhere, Oracle, etc.), use remote views.

>
>1)What are the performance penalties, if any, for using Remote View instead of Local Views.
>

You're adding an ODBC layer on top of your app, so you'll notice the difference in performance. I don't have any numbers to give you, though. There are some cases where remote views for VFP data might make sense, but for most cases there isn't any benefit, and there are penalties.

>
>3) How to create a connection string for the remote view at runtime. Because, the datasource for the clients is going to be different for each computer the software is installed on.

Take a look in the MM's DevGuide (around page 174). There is a section about creating named connections. It's basically the CREATE CONNECTION command.

>
>4)Does the Remote View provide me with a Stateless connection to my data. In other words does the Remote View keep a connection to the data open or hard wired?
>

The framework can/will maintain a single shared connection to the backend.

>5)What is the best option for providing a Row Source from these free tables?
>

Not sure what you mean here.

HTH
-Paul

RCS Solutions, Inc.
Blog
Twitter
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform