Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed with ODBC using SYBASE SQL Anywhere
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00099363
Message ID:
00099733
Views:
26
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform