>>>I have a VFP 3.0 application using remote views and a named connection to an Informix database. The response time, both to establish a connection via USE view_name NODATA, or REQUERY('view_name') is in the order of 3-4 minutes. My development system is a 120 pentium, 64mb RAM, 1.2 gb HD. The Informix database is accessed over a shared T1 WAN.
>>>
>>>If I connect to the same tables using the same ODBC drivers via Crystal Reports or using different drivers on another SQL program, the response is within 3-5 seconds. Response is also excellent if I execute the queries using SPT at the VFP command window.
>>>
>>>Anyone out there have a similar experience or suggestions on a fix? TIA - Bob
>>
>>You don't happen to have tracing in ODBC, do you?
>
>No, but that's one I didn't think of. Thanks

Try playing with the advanced options in the view to see if it improves.