Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View is slower?!?!?!
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00311191
Message ID:
00316978
Views:
19
Rich,

My experience with remote views is with a Fox database on the backend. I do not know if the following comments apply to SQL Server, Oracle, etc...

A remote views work very well for updating, inserting and deleting data. They are extremely slow, however, for record selection. This is because VFP pulls the entire dataset before applying any filters. For this I use SQL Passthrough to query the data, and the database only sends the filtered dataset.

I do not believe that you can call a stored procedure in a remote VFP database.

Phil
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform