Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC connection to Oracle performance
Message
 
 
À
09/07/1999 09:42:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00239391
Message ID:
00239428
Vues:
16
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform