Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up ODBC
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00083856
Message ID:
00084072
Views:
24
>SELECT * FROM employee
>
>which returns 440 records
>via SQLEXEC - 6 seconds
>via ISQL - approx 1 seconds
>
>Any ideas?

Sounds like ISQL is probably using a native driver for SQL Anywhere and SQLExec is using a much less efficient ODBC driver. Does Sybase's website have any helpful info about ODBC tips or latest drivers?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform