Parallelise Function call
From: valigula <valigula_at_gmail.com>
Date: Sat, 8 May 2010 01:49:38 -0700 (PDT)
Message-ID: <270f4fa1-d9a9-4234-a57a-85fddf628254_at_d19g2000yqf.googlegroups.com>
Hi all,
Date: Sat, 8 May 2010 01:49:38 -0700 (PDT)
Message-ID: <270f4fa1-d9a9-4234-a57a-85fddf628254_at_d19g2000yqf.googlegroups.com>
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). 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 Received on Sat May 08 2010 - 03:49:38 CDT