Hello,
I have a set of plsql functions that I want to execute. All these functions
perform queries and insert data in the database and I need to execute them
in order.
What I have noticed is that if I execute this script

BEGIN;
SELECT function1();
COMMIT;

BEGIN;
SELECT function2();
COMMIT;

BEGIN;
SELECT function3();
COMMIT;

it takes more time than if I execute one function at the time and sum the
execution times of each one:

BEGIN;
SELECT functionX();
COMMIT;


In some cases if there are several millions of tuples in the database
running all the rules in the same script takes 10 times more than running
one at the time.

Can anyone explain why this happens and how can I prevent it?

Thanks for the help.

Filipe

Reply via email to