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:
00099599
Views:
18
Steve,
I have some experience in getting at SQL Anywhere data. What I found is that if you select all columns from a table (even with just 500 rows) it is really slow. I changed my queries to only select the columns I needed and it sped up the process dramatically.

Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform