Re: Partitioning best practices

  • From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
  • To: tboss@xxxxxxxxxxxxxxxxxx
  • Date: Fri, 1 Sep 2006 14:54:32 -0700


FWIW, Doug Burns had written an excellent article on PQ - you will
find it in the archives in the Q3 2005 issue.

Followup question for you JL in re parallelism: we're having a
hell of a time deciding how to use parallelsm in regular operations.
When we have it turned on, any query immediately pops up 8 parallel
engines and completely hogs all the CPU and i/o channels to the data,
effectively serializing database access and killing overall performance.
Is the only way to really figure out what the best solution is
to just do trial and error with degrees and options til you find
a workable solution?  Or do you even use parallel server outside
of loading?
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **

Other related posts: