>My company is being asked to make our product work with SQL Server data instead of it's local native VFP 5.0 databases. We know we can do it, but having never used Remote Views, one of our biggest questions is: On a big inventory system, how do we keep all of the Clients views updated in a timely manner? We are working with 50,000 - 100,000 records and it takes forever to bring all of that over from SQL. I know everyone who has done Client/Server before has answered this question...any help? Thanks
Tim, I am not sure what forces you to bring all the records through SQL, because the main idea of C/S - to bring only small record set, or even just one record (say, for updating single inventory entry). If you have set right indexes on your back end tables and created the right views, taking advantage of your indexes, retrieving of records usually is a matter of seconds.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison