>Hi,
> I am using VFP DB in my multiuser application.
> I would like to know, where will the comparison being done? I heard that, the index of the table will be sent to the workstation which call the SQL, and then only pull the actual data needed from server.
> Since everything done by workstation, is it meant we need more powerful workstation instead of powerful server?
> Please advise
>
>Thank you

All processing for VFP is done at the workstation. It is not a client server environment.

Server Guidelines
Fast enough and powerful enough to handle file locking a serving
Large amounts of memory to handle disk caching or a fast disk system

Network Guidelines
100BaseT - fastest, cheapest pipe to feed you your data

Workstation Guidelines
Large amounts of memory for faster processing and less disk swapping
Fast CPU for better procesing times

Since terms like "fast" and "large" are relative to the applications you will be running, you have to figure the actual numbers for yourself.

HTH.