Hi all!

Creating a remote view connected to MySQL data take a very long time to =

complete,

as if the code to create the view is actually causing a SELECT to be =

performed on the MySQL backend database.

Sample code:

create sql view "MyView" remote connection "MySqlConnection" as ;

select * ;

from MyTable ;

where MyCode =3D ?vp_code

The creation of the remote view takes a long time and the amount of time =

it takes

seems to be proportional to the amount of data in the backend table.

The same operations connecting to MS-SQL data are almost istantaneous.

Anyway, once created, these views work as they should.

Anyway SPT access to MySQL data is fast.

All tests are done locally.

Does this behavior sound familliar to anyone?

Does anyone have any suggestions?

My system is as follow:

Windows XP Pro SP3

VFP 9 SP1

MySQL Server 5.1

MySQL ODBC 5.1 Connector

MySQL ODBC 3.51 Connector

MS SQL Server 2008

SQL Server Native Client 10.0

--=20

Gianni