>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