Update 3 columns w/ 1 function calc 3 values?
От | paallen@attglobal.net |
---|---|
Тема | Update 3 columns w/ 1 function calc 3 values? |
Дата | |
Msg-id | 20061003145559.C55369FB26B@postgresql.org обсуждение исходный текст |
Ответы |
Re: Update 3 columns w/ 1 function calc 3 values?
Re: Update 3 columns w/ 1 function calc 3 values? Re: Update 3 columns w/ 1 function calc 3 values? |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: