Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC performance
Message
From
01/04/1997 21:20:54
Jack Pan
China System Nanjing
Nanjing, China
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
ODBC performance
Miscellaneous
Thread ID:
00026494
Message ID:
00026494
Views:
81
hello, everybody. i had question about ODBC performance here. We need create a cursor inside MS SQL Server which was joined from two tables each contained 10,000 records. SQL commands to create cursor took about 5~8 seconds when executed from ISQL.EXE but it takes more than 50 seconds if it's sent by VFP SQL pass through via ODBC. Can anybody had same experience give me some suggestion on ODBC performance tuning?

thanks a lot.
jack
Next
Reply
Map
View

Click here to load this message in the networking platform