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,

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

Original text of this message