From: paallen@attglobal.net
To: pgsql-sql@postgresql.org
Subject: Update 3 columns w/ 1 function calc 3 values?
Date: Tue, 03 Oct 2006 14:55:55 +0000
Message-ID: <20061003145559.C55369FB26B@postgresql.org> (raw)
Hi all,
I am moving some of my old MS Access functions to
plpgsql.
My function was made to return coordinates, X,Y,Z
for a point along a curved line. So it is not the
fastest of functions because it has to call and
query data from 3 different tables. I used to
just create 3 wrapper functions for my main
function which would return the x, y, and z values
seperately but that requires the main function to
be called 3 seperate times. So here is my bottle
neck. Of course I need to update +50,000 records.
What should I do to speed this up. What is the
best way to update 3 columns from one function
call. In MSACCESS I once rig the function to
cycle through the records with a curser but that
was slow and would crap out due to the shear number.
Thanks,
Phil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: paallen@attglobal.net
Subject: Re: Update 3 columns w/ 1 function calc 3 values?
In-Reply-To: <20061003145559.C55369FB26B@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox