You don't define the type of data that you are using.
- If Fox data, the query is resolved on the client.
- If a data server, such as Oracle or SQL Server, the query is resolved on the server.
>I have a (remote) server that houses my data. I have also placed my executable file on the server. User run the .EXE file from user's (local) computer (I have a shortcut set to point to the .EXE file on the server).
>
>If I have a SQL SELECT statement (in my .EXE file):
>SELECT * FROM myTable
>data is retrieved using the server's processor or the user's local processor/computer?
>
>What I'd like to know is:
>does the server need to have a good/powerful processor (if data is retrieved using server's processor) or it makes more sense to have a good/powerful user computer (if processing happens at the user's end).
>
>Thank you all!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer