On Tue, 03 Feb 2009 09:17:14 -0800, Paul McNett <[email protected]> wrote:
>Gianni Turri wrote: >> 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? > >Yes, I remember having similar problems. Check the log on the server to see >the >queries being sent. Because of multiple problems with remote views (and local >views) >in VFP, I went with a 100% SPT solution. You can easily make SPT cursors >updateable, >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? -- 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.
