>Hi Dave,
>
>I use remote views for data entry screens. I have copies of lookup tables that I store locally in VFP on the client machine to speed up performance.
>
>I use SQL pass through to execute stored procedures on SQL Server. Since the stored procedures are compiled on the server, performance is very good. I have had to learn the SQL syntax of SQL Server to write these stored procedures. It is a fair bit of work.
>
>I think this is the recommended approach. It seems to work very well.
>
>Good luck,
>
>Paul de Niverville
>
>
>
>>>Hi Dave,
>>>
>>>>which method results in better query performance ?
>>>>
>>>>Remote views or SQL pass through?
>>>The answers may vary on this one. I don't think there is much difference speedwise, though you might get a slight advantage when using passthrough to retrieve data.
>>>
>>>>which method gives better batch update performance ?
>>>It will be nearly the same but views will provide more flexibility for manupulating data. If you are looking for large batch updates consider looking at BCP.
>>>
>>>>if i send a query through SQL pass through does the SQL syntax have to be in the server's SQL syntax or in VFP SQL-Select syntax ?
>>>Server's
>>>
>>>>do i have to learn the SQL syntax of SQL Server 6.5 if i use SQL pass through to access its data ?
>>>Yes. Its very similar though but you could do a lot more with SQL Server.
>>
>>your help is greatly appreciated ...
>>
>>Dave.
Do you store the lookup tables on every client machine?
How do you regularly update these tables on the client machine?