>Hi ,
>I have this app running on the network in which users have to access just certain records based on their access permissions.Now my question is does this table filteration happen on the server where the table is or the whole records from the table are sent to the client machine and then the filteration happens ?
>In other words, when I apply complex FILTER statement on a shared table , do I reduce the network traffic or just increase overhead in the client ?
>
Hi Saeed,
All processing happens on the client machine regardless of what you do. In case when FILTER conditions are Rushmore optimizable Foxpro would use indexes to determine what records to pull from server and that could reduce network traffic. Take a look at 'Optimizing Applications' at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/foxhelp98/dgoptimizing_applications.asp.
--sb--