VFP remote view creation very slow....
Posted by: Alec Gagne
Date: October 03, 2008 11:11AM

Any Visual FoxPro (VFP) folks out there?

The VFP9 code to create a remote parameterized view (this is not a MySQL view) in a local database container file (DBC) seems to take a long time to complete, as if the code to create the parameterized view is actually causing a SELECT to be performed on the MySQL backend database. Example VFP Code:

CREATE SQL VIEW "V_MV_INDEX" REMOTE CONNECT "mysql_connection" ;
AS SELECT mv_index, veh_license, veh_state FROM mvehicle_index ;
WHERE veh_license = ?pcvlicense

When connecting to MS-SQL Server via ODBC this code works as expected/documented, simply creating the view definition (sort of a locally stored persistent SQL Statement) with a "?" placeholder for a variable that is defined at runtime, without launching any kind of search or select in the backend database. However, using the MySQL ODBC 5.1 Connector (also tried the 3.51 Connector) the creation of these VFP remote views takes a long time and the amount of time it takes seems to be proportional to the amount of data in the backend table.

More Details: Once created these views work as they should; no problem. Likewise my SQL passthru (SPT) code works very fast.

Does this behavior sound familliar to anyone? Does anyone have any suggestions?

Alec

Options: ReplyQuote


Subject
Views
Written By
Posted
VFP remote view creation very slow....
13111
October 03, 2008 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.