Jean-Paul ARGUDO wrote:
>As I wrote it before there, it is an ECPG script that runs with bad perfs.
>I put back trace/ notices/debug mode on the server.
>
>Here is an example of what does the debug doesnt stop to do:
>
>c... stuffs are CURSORS
>
>it seems that on every commit, the cursor is closed
>
>[... snip ...]
>NOTICE: Closing pre-existing portal "csearcht04"
>
...
>NOTICE: Closing pre-existing portal "cfindplu"
>NOTICE: Closing pre-existing portal "cfindplu"
>NOTICE: Closing pre-existing portal "cfindplu"
>[... snip ...]
>
>c... stuffs are CURSORS
>
>it seems that on every commit, the cursor is closed... and re-opened with new
>variables'values
>
By default, Postgres executes transactions in autocommit mode.
This means that each statement is executed in its own transaction and a
commit is performed
at the end of the statement, what is much slower than executing all
statements inside a
begin ... commit block.
To disable the autocommit mode you have to compile the ECPG script with
the -t option.
I Hope that it helps.
Regards,
Antonio Sergio