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 = ?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
--
Gianni
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
