Re: 5.02 ??

Posted in 1997

"Billy Wheeler" — 23 Oct 1997 02:13:14 -0400 — source: Informix-list mailing list archive (1991-1998)

On 22 Oct 97 at 16:57, David Coburn wrote: > I'm used to seeing DSA split up a task over multiple threads and > processes, but under what conditions would 5.02 do the same? I have > a long running query that is outputing to a file. it gets to about > 65 MB of output and then promptly splits off another sqlturbo > process. The new process has the same tty, a new pid, and begins to > accumulate stats, too. Have you got PSORT_NPROCS set? That forces parallel sorting and (I think) index builds. Like temporary indexes? HTH. Straw-clutchingly yours... -- Ciao, Billy Nose to the ear in Johannesburg -- Murder City never looked so good! Get the Informix FAQs of life at http://www.iiug.org/techinfo/faq/faq_top.html Need to get some drivel into your life? http://www.west.co.za/tasteless/