Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up ODBC link to SYBASE SQL Anywhere
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00098850
Message ID:
00098866
Views:
29
Steve,

Even views with NODATAONLOAD can take a little time to load. VFP does a query on the backend which returns an empty cursor. You may want to take the views out of your data environment and only open them as you need them.

>I am wondering if anyone has any hints on speeding up form instantiation with SYBASE SQL Anywhere as an ODBC client. DBCLIENT is started prior to form instantiation. The form is taking about 12 seconds to appear with 3 tables being loaded with 500,20,20 records respectively. There are 12 other views that have NODATAONLOAD set to TRUE.
>
>I would greatly appreciate any hints. Thanks
>
>Steve Smith
Previous
Reply
Map
View

Click here to load this message in the networking platform