Re: performance tuning in large function / transaction

On Fri, 14 Dec 2001, MindTerm wrote:

> Hi all,
>
>   table :
>   application : 220 rows ;
>   usermenu    : 6055 rows ;

Well, I'd need the other tables involved in the function
too, but to start with, try rewriting the queries in the
function to use EXISTS rather than IN (see the faq), or
bring them into a normal join with the other tables where
possible.