Re: [GENERAL] Executing more than one function.

2011-08-23 Thread Giuseppe Sacco
Il giorno mar, 23/08/2011 alle 16.30 +0100, f vf ha scritto: [...] > 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; > You should probably accout a time for the COMMIT operation. In one case yo

[GENERAL] Executing more than one function.

2011-08-23 Thread f vf
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