Re[2]: Update Statistics Speedup Help???

Art, Can you put the PSORT_NPROCS parameter in the onconfig for all sessions to pick up? If not how do you get all sessions to use it? If it is added to the general login profile is it picked up by a client server connection? Regards David Ashby ______________________________ Reply Separator _________________________________ Rick Bernstein wrote: > > At 04:47 PM 1/13/98 -0500, you wrote: > } [SNIP] > What does item 4 (Set PSORT_NPROCS>=40) accomplish? > My Informix documentation states that the upper limit for the > PSORT_NPROCS environment variable is 10. The manual lies. Or the tech writer was misled. Try it and see. Besides the faster sort times you can see the extra resources being allocated in onstat -g ses <sessid>. you don't have to trust me on this one. Check it out. Art S. Kagel