Re: Newbie Client-Server select Query Question by George
George
Fri Jan 06 01:58:26 CST 2006
Marina wrote:
> No, you are still being very vague on what a client is in your
> understanding, and what a server is. That answer did not clear anything up,
> really.
>
> Well, presumably the client tells the server to run a query for it. So of
> course the server is the one that handles this request. The client in this
> case just passes along the query it wants run, and that's it. This is the
> only client/server scenario I can imagine, or else you don't really need a
> server.
>
> But, in this case, I am not sure why you would ask this question. Since the
> whole concept is that the client asks the server to run the query - and the
> server goes to the database. So there is no possible way the client can be
> handling running the query.
>
> The server, however, is responsible for connecting to the DB, etc, but of
> course it is the database server that runs the actual query. The database
> server parses the query, creates the execution plans, and goes gets the
> data. The server component of an application is not itself a database
> engine, it is just handling client requests.
>
> Only the database server/engine ever truly executes queries. It returns the
> result set to whoever requested it - in this case the server component of an
> application, which in turn hands the data over to the client application.
>
>
> "jepsen,andy" <jepsenandy@nospam.com> wrote in message
> news:eBjMHTJEGHA.740@TK2MSFTNGP12.phx.gbl...
>
>>Suppose I have 2 system. One is the server another is just a client to
>>communicate with the server.
>>My question is if I do a query from the client then will it do the
>>processing at the server or at the system where we ran the query.
>>
>>I hope this is clear.
>>Thanks, Andy
>>
>>"Marina" <someone@nospam.com> wrote in message
>>news:et3%23oIJEGHA.3052@TK2MSFTNGP10.phx.gbl...
>>
>>>What does 'client system' mean. What exactly is your scenario. What is
>>>the structure of the application.
>>>
>>>"jepsen,andy" <jepsenandy@nospam.com> wrote in message
>>>news:u3hSyoIEGHA.472@TK2MSFTNGP12.phx.gbl...
>>>
>>>>It might be a very basic question, but I don't the answer. Please clear
>>>>my boubt.
>>>>
>>>>From the client system when we execute "select * from Employee" where
>>>>does the execution takes place.
>>>>Does it execute it at server or at client.
>>>>Do we need to have a high power client to do any queries.
>>>>
>>>>Please Help,
>>>>Andy
>>>>
>>>
>>>
>>
>
>
Hi,
The only thing I would add here is that you really do not need a
powerful client in order to view the results of complex queries.
The client, however, needs to be powerful enough to support the
application that you are going to be running on it, regardless of the
time it takes to process sql commands.
Regards,
George