Re: Multi-process V.S. single-process

From: "Christian Allaire" <c_allaire@hotmail.com> > >This is not directly related to informix products, but it raises >a question concerning a design issue for a report batch processing >system using an Informix SE 7.10 DB on a Sco/Intel server with 2 CPU. > >Our team had an argument over which is the best way to go for a >night batch processing system: > >A) Starting multiple reports at once using a driver report that will > issue multiple fglgo commands (with the RUN ... WITHOUT WAITING > command). > >B) Starting one report at a time using a driver report that will > issue one fglgo at a time, waiting until the end of execution > before starting another (with the RUN ... command). > >Which option would be the less time consuming and the most efficient, >considering our hardware and software ? Also take into account that >these are all reports that only do selects, no inserts deletes or updates. It's practically impossible to say. I'm guessing that the optimum will actually be somewhere in between, where you run N concurrent reports, because you should get some benefit out of running more than one at a time, but running them all at once might thrash the machine a bit. It depends on the complexity of the reports and the volumes of data. You might have to sort the order in which you fire the reports off a little as well. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com