[GENERAL] optimising the pl/pgsql function

Started by VENKTESH GUTTEDARover 7 years ago2 messagesgeneral
Jump to latest
#1VENKTESH GUTTEDAR
venkteshguttedar@gmail.com

Hello,

We are running a pretty big plsql function, we are fetching data from
some tables based on certain conditions. And using that data in a for loop
within the function.
the problem we are facing is when the no of records are more the function
ction is taking too much time, is there a solution to this problem? Can we
replace the for loop with something else?

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: VENKTESH GUTTEDAR (#1)
Re: [GENERAL] optimising the pl/pgsql function

On Tue, Sep 18, 2018 at 11:37 AM, VENKTESH GUTTEDAR <
venkteshguttedar@gmail.com> wrote:

Can we replace the for loop with something else?

A query probably - depending on what the function does and, in particular,
whether dynamic SQL is required.

David J.