I'm using VFP 5 to query against a remote Oracle 7 database.
The queries themselves run fine, but when defining Remote Views,
the process can take up to 20 or 30 seconds.
Is there any DBPROP that I should set to help this? And is there
any particular reason why this should take so long? It's not
even clear to me why there's a need to connect to the remote
datasource, except to validate table/column names, right?
The views are simple, single table views that simply create
an alias and return perhaps 8 or 10 columns out of the original
30 or 40 columns in the remote table.