Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Remote view using odbc to an AS400.
>
>Select * from myfile where keyfield = 'Somevalue'
>runs sub second
>
>gn = sqlconnect("sameDSNin remote view connection","sameid","samepass")
>sqlexec(gn,"Select * from myfile where ketfield ='Somevalue'","test")
>runs in 30 to 40 seconds.
>
>both return less than 30 records.
You don't specify how the remote view is getting connected. If it is using a DBC connection what are the settings? Perhaps one is doing a progressive fecth and the other isn't...
Use SQLGetProp() on the views connection and check all the properties and compare them to the same properties on the SPT connection. I would bet that you find some different settings.
BOb
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement