Re: [GENERAL] optimising the pl/pgsql function

2018-09-18 Thread David G. Johnston
On Tue, Sep 18, 2018 at 11:37 AM, VENKTESH GUTTEDAR < venkteshgutte...@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.

[GENERAL] optimising the pl/pgsql function

2018-09-18 Thread VENKTESH GUTTEDAR
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 solut