On Tue, 03 Feb 2009 09:17:14 -0800, Paul McNett <p@ulmcnett.com> wrote:

>Gianni Turri wrote:

>> Hi all!

>>=20

>> 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.

>>=20

>> Sample code:

>>=20

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

>> select * ;

>> from MyTable ;

>> where MyCode =3D ?vp_code

>>=20

>> 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.

>>=20

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

>>=20

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

>>=20

>> Anyway SPT access to MySQL data is fast.

>>=20

>> All tests are done locally.

>>=20

>> Does this behavior sound familliar to anyone?

>> Does anyone have any suggestions?

>

>Yes, I remember having similar problems. Check the log on the server to =

see the=20

>queries being sent. Because of multiple problems with remote views (and =

local views)=20

>in VFP, I went with a 100% SPT solution. You can easily make SPT cursors=

updateable,=20

>getting you everything a remote view gives you. See:

>

>ftp://leafe.com/makeupdatable.prg

Hi Paul,

thanks for your reply.

Would be my intention to use remote views in some places.

The problems with remote views you mentioned are only with MySQL or even =

with MS SQL?

Can you give me details about the problems you've encountered?

--=20

Gianni