Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed with ODBC using SYBASE SQL Anywhere
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00099363
Message ID:
00099733
Vues:
27
Hi Mike,

>I've had similar problems using an Oracle back-end. When I change my views to share a connection I get errors when the dataenvironment inits.

the best way is to create the connection when your application loads up. The views could be based on this connection and that will help in speeding up the loading of views (i.e. forms)

VFP's native behaviour for remote views is:
- Establishes the connection when you load the views if the connection does not exist
- 2ndly when you unload your form it disconnects the connection if no other view in other form is using the same connection

So if a user is just using one form then the connection is established when the form is loaded and released when the form is unloaded. The cost of establishing a connection (in time) is expensive.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform