>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao