Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC connection to Oracle performance
Message
 
 
To
09/07/1999 09:42:02
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00239391
Message ID:
00239428
Views:
13
>I have a VFP6 connection to a Oracle 7.3 database that works but does not seem to be using the Oracle indexes for queries. Is there anything that can be modified in the ODBC data source or the VFP remote view to fix this?
>
>If not, are there any native drivers for Oracle that work with VFP?
>

Also, I doubt that the drivers are the source of your speed problems. ODBC drivers basically just translate the SQL to the proper syntax needed by the backend DB. From that point, the DB engine takes over running the query. Once the results set has been determined, returning the data over the connection is a result of available bandwidth, number of records, record size, etc. The drivers have very little affect on speed.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform