Hi roy,

>Let me put it this way, if I do sql passthru let's say from foxpro to SQL Server as example "select * from customer where ncust_id = 3" then only one record goes over the wire,but if the database is foxpro and there's 1 index on ncust_id and I have the same query, what would be transferred over the wire apart from the one record?

Well first the indexfile is examined in a B-Tree way. This is something you won't have in SQL server. This ussually is very fast. After that only the one record is requested from the server.

However it is important to note that since VFP is a file-server database some administration messages are also send and retrieved. You can see what exacly is send accross the wire and the amount of time consumed with filemon available from www.sysinternals.com.

Walter,