Re: Parallelise Function call

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 8 May 2010 19:20:44 +0000 (UTC)
Message-ID: <hs4dic$ol$1_at_news.eternal-september.org>



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
> servers.
> 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.

-- 
http://mgogala.byethost5.com
Received on Sat May 08 2010 - 14:20:44 CDT

Original text of this message