Re: Parallelise Function call
Date: Sat, 8 May 2010 19:20:44 +0000 (UTC)
On Sat, 08 May 2010 01:49:38 -0700, valigula wrote:
> Hi all,
> I need to run a function/procedure/script using a dblink between two
> The query itself uses two views on the remote server, the views are only
> effectives when passing 1 paramente, I need to run 20 k (ish).
You should be in good shape to run 20k. I ran 5k (3m) on the treadmill last night and it was absolutely exhausting.
> As an
> interim solution i create a function that do the select one at the time
> , but the time consuming it is quiet large and thinking on turning it, I
> was suggested to parallelise the function call within the select. But
> not really clear in how to do that.
> Any ideas or suggestions wil be appretiatte
Shoot your application designer or, worse, force him to learn about materialized views and STREAMS.Received on Sat May 08 2010 - 14:20:44 CDT