|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Newbie Client-Server select Query QuestionIt 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 What does 'client system' mean. What exactly is your scenario. What is the
structure of the application. Show quote "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 > 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 Show quote "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 >> > > Andy,
If by server you mean a true RDBMS such as SQL Server, Oracle, DB2, etc., then the processing will be done at the server and the resultset will be returned to the client. Of course, if by server you mean an Access database file then the processing will be done on the client, regardless of where the Access file is located. Kerry Moorman Show quote "jepsen,andy" wrote: > 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 > >> > > > > > > > Much of that depends on the design of your provider and the database.
I believe with MS SQL server (all variants), the query is passed to the machine where the SQL Server is actually installed. I have also worked with older systems (such as a Thoroughbred DB that uses flat files) where the ODBC client does all the work...which means that the client machine itself needs to have some processing power behind it. 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. Show quote "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 >>> >> >> > > Marina wrote:
Show quote > No, you are still being very vague on what a client is in your The only thing I would add here is that you really do not need a > 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, 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  |
|||||||||||||||||||||||
Other interesting topics