Re: 4GL - Server or Client Side?

What do you mean the application is run on the client PC? And how come the database is on an NT box? Are you using Informix 4GL or Dynamic 4GL? Don Kirk Davis wrote: > > The application is run on a client PC, and the database is held on an NT > server. It just seems that there is a lot of activity across the network > when we are running queries. > > Thanks for the reply........... > > /Kirk > > Michael Krzepkowski <michaelk@sqlcanada.com> wrote in message > news:3950D0FF.B47AA5C8@sqlcanada.com... > > Hi! > > > > Do you have the database on a separate system? > > SQL statements are executed by the engine, program statements (like > counters, > > display, print ) are executed in the running program. > > > > Does this answer your question? > > > > Michael > > > > > > Kirk Davis wrote: > > > > > Hello again experts, > > > > > > We run a fairly old application, written in Informix 4GL, which queries > a > > > database (originally SE, but recently upgraded to IDS 7.3). The question > I > > > have is : Will the queries which are run from the 4GL application be > > > executed server side or client side?? > > > > > > There is a counter which counts the number of lines read onto the > screen, > > > but it doesn't show whether the work is done at the server or at the > client. > > > > > > Thanks for your help..... > > > > > > Regards, > > > Kirk > >

WE are using Informix 4GL, and the 4GL application in run from an NT workstation on our LAN, and the database is run on IDS 7.3 on an NT Server. /Kirk Don Ignacio <dignacio@openratings.com> wrote in message news:8ir0rl$q4m$1@news.xmission.com... > > What do you mean the application is run on the client PC? And how come > the database > is on an NT box? Are you using Informix 4GL or Dynamic 4GL? > > > Don > > Kirk Davis wrote: > > > > The application is run on a client PC, and the database is held on an NT > > server. It just seems that there is a lot of activity across the network > > when we are running queries. > > > > Thanks for the reply........... > > > > /Kirk > > > > Michael Krzepkowski <michaelk@sqlcanada.com> wrote in message > > news:3950D0FF.B47AA5C8@sqlcanada.com... > > > Hi! > > > > > > Do you have the database on a separate system? > > > SQL statements are executed by the engine, program statements (like > > counters, > > > display, print ) are executed in the running program. > > > > > > Does this answer your question? > > > > > > Michael > > > > > > > > > Kirk Davis wrote: > > > > > > > Hello again experts, > > > > > > > > We run a fairly old application, written in Informix 4GL, which queries > > a > > > > database (originally SE, but recently upgraded to IDS 7.3). The question > > I > > > > have is : Will the queries which are run from the 4GL application be > > > > executed server side or client side?? > > > > > > > > There is a counter which counts the number of lines read onto the > > screen, > > > > but it doesn't show whether the work is done at the server or at the > > client. > > > > > > > > Thanks for your help..... > > > > > > > > Regards, > > > > Kirk > > >

Kirk Davis wrote: > > WE are using Informix 4GL, and the 4GL application in run from an NT > workstation on our LAN, and the database is run on IDS 7.3 on an NT Server. But C4GL/R4GL do not run on NT!?!??!? Anyway to you original question, SQL will be executed on the server, that does not mean that the 4GL was written to take any advantage of that fact. It may be querying with a very broad filter and further filtering the rows after they are returned by the server which MIGHT explain why you are seeing lots of activity on the client. Art S. Kagel > /Kirk > > Don Ignacio <dignacio@openratings.com> wrote in message > news:8ir0rl$q4m$1@news.xmission.com... > > > > What do you mean the application is run on the client PC? And how come > > the database > > is on an NT box? Are you using Informix 4GL or Dynamic 4GL? > > > > > > Don > > > > Kirk Davis wrote: > > > > > > The application is run on a client PC, and the database is held on an NT > > > server. It just seems that there is a lot of activity across the network > > > when we are running queries. > > > > > > Thanks for the reply........... > > > > > > /Kirk > > > > > > Michael Krzepkowski <michaelk@sqlcanada.com> wrote in message > > > news:3950D0FF.B47AA5C8@sqlcanada.com... > > > > Hi! > > > > > > > > Do you have the database on a separate system? > > > > SQL statements are executed by the engine, program statements (like > > > counters, > > > > display, print ) are executed in the running program. > > > > > > > > Does this answer your question? > > > > > > > > Michael > > > > > > > > > > > > Kirk Davis wrote: > > > > > > > > > Hello again experts, > > > > > > > > > > We run a fairly old application, written in Informix 4GL, which > queries > > > a > > > > > database (originally SE, but recently upgraded to IDS 7.3). The > question > > > I > > > > > have is : Will the queries which are run from the 4GL application be > > > > > executed server side or client side?? > > > > > > > > > > There is a counter which counts the number of lines read onto the > > > screen, > > > > > but it doesn't show whether the work is done at the server or at the > > > client. > > > > > > > > > > Thanks for your help..... > > > > > > > > > > Regards, > > > > > Kirk > > > >