Re: Distributing 4gl's To Application Server

rico@wsx.wsex.com wrote: > > Hello All, > > Pardon the rather general question. > > I currently run all 4gl's and scripts on the same server as the > database engine. I am planning to move the 4gl's and scripts over to > a seperate server. > > I am using Online 5.0 and am upgrading to IDS 7.3. > > In making a transition like this, what things should I be thinking > about. Am I going to have to start using stored procedures a lot more? > Or should everything work similair to the DB engine being on the same > machine? Everything should work pretty much the same as before. Of course if your applications are poorly designed and retrieve and manually filter lots of data that they do not need, then rewriting your queries to be more specific or using stored procedures to perform more complex filter processing WILL save you lots of communication overhead. Conversely, you may find that nested 4GL loops instead of SQL joins will perform better again because of the reduced communications overhead. Art S. Kagel