Re: slow DSS large dataset query, help

Posted in 1999

Obnoxio The Clown — Thu, 09 Sep 1999 12:04:24 BST — source: Informix-list mailing list archive (1991-1998)

More thoughts below: From: sjsyau@my-deja.com > >NUMAIOVPS 6 # Number of IO vps This is very low, unless you are using KAIO. Also, are these tables fragmented? Are you using PDQ? HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

sjsyau@my-deja.com — Thu, 09 Sep 1999 18:26:59 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7r84ru$i7c$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > More thoughts below: > > From: sjsyau@my-deja.com > > > >NUMAIOVPS 6 # Number of IO vps> > This is very low, unless you are using KAIO. > Not using KAIO, So how many IO vps I should have? > Also, are these tables fragmented? No. > Are you using PDQ? No, not this session. But another important session use PDQPRIORITY 80. Should I use PDQ for this query? SJ Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.