Re: slow DSS large dataset query, help

From: sjsyau@my-deja.com > >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? Arg. How many disks have you got? It might be easier to just try enabling KAIO. And on some ports, KAIO is enabled by default. > > Also, are these tables fragmented? > >No. You *really* *should* fragment them, even if it's just by round robin, otherwise you aren't really going to get the best use of your server. > > Are you using PDQ? > >No, not this session. But another important session use >PDQPRIORITY 80. >Should I use PDQ for this query? Yes. But fragment the bigger tables first. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com