>>>However, I have found that by using views to access the data I need from J:\DBFS\CLIENTS.DBF was faster that using SELECT * FROM CLIENTS...
>>>
>>
>>I don't know too much about NT or C/S, but I can give you a tip about SQL:
>>If you specify all the fields you want selected from the table (even if it's all fields) it will be much faster than '*'. It has always been like that...
>>
>>Alex.
>
>Yup. Another reason for that would be if you add some fields on the Server side that you don't want reflected on the client side. Using * gives you everything, and thus you would need to change your app. (Learned that one the hard way!)

I thought so! That's why you look so tanned in the picture! :-)

>
>Scot.

I was just talking about speed, but that's true too (unless you do want the changes on the server to reflect on the client's side :-) ).


Alex.