Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views or SQL Passthrough, ADO or ODBC
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00272617
Message ID:
00272710
Views:
25
>Thanks Mark,
>
>Although distance is meaningless using TCP/IP, network traffic costs us money. What we really do not want is all the records of a result set coming down the network, every time the view needs to get updated. We just want the updated/ inserted stuff to to travel, and I need confirmation of that!
>

Design parameterized remote views to retrieve only the records your end-user will need to work with. The updating process will only send back to the server those new or modified data and deleted record information. So if you retrieve 10 records and the user only modifies 1, the information from just the 1 record will be sent back to the server for updating.

Your design will not have much affect on sending information to the server, but it sure will be a major factor on what is retrieved from the server.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform