Re: Parallel queries slow

From: Marek Läll <marek_at_eesti.umbluu.ee>
Date: Thu, 22 Dec 2005 21:37:37 +0200
Message-ID: <doeva3$di7$1@kadri.ut.ee>

Hi,

> The problem: When I execute a query it takes about 3 seconds when
> executing it in parallel. When I specify the hint NOPARALLEL it takes
> only about 0.2 secs.

If your query (in noparallel mode) takes less than ~10 minutes then forget everything about parallel queries.
Allocating slaves AND shareing work between slaves AND exchangeing results between slaves AND finally merging results for serial user is very expensive task.

regards,
marek. Received on Thu Dec 22 2005 - 13:37:37 CST