Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ConnString and Asynchronous behavior
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ConnString and Asynchronous behavior
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01386082
Message ID:
01386082
Views:
126
For about 6 months now, one specific form in an application loads very slowly in the development environment. Since it doesn't happen at the client site, I haven't bothered to look into it until today. The slowness was traced to the method that loads 12 remote views for SQL data. The USE command for each contains the ConnString clause and a string value. Most also contain the NODATA clause but 2 views load with data. The tables for these are typical lookup tables, each with 2 or 3 fields--one with 10 rows and the other with about 50. When using the string value for ConnString, the method took 13 seconds to execute! However, when the connection handle was substituted for the string, the views opened in less than 1 second--but there was a "connection busy" message when loading the second view containing data. It would appear that the connection behaved asynchronously even though it is defined with asynchronous = .f. Why is there such a big difference in performance between the connection string and the connection handle? Why was there a connection busy message?
Next
Reply
Map
View

Click here to load this message in the networking platform