Hi,
I have a very poor testing performance when I step into a
FOR c in (SELECT abc(column) ...) LOOP
with a function call (abc) within the select part.
Allthough I switched off debug information for that function it takes a lot of minutes until I can step on.
I discovered a lot of data sent over the network to the db-server during waiting.
Any ideas/hints?
Regards,
Dirk
I have a very poor testing performance when I step into a
FOR c in (SELECT abc(column) ...) LOOP
with a function call (abc) within the select part.
Allthough I switched off debug information for that function it takes a lot of minutes until I can step on.
I discovered a lot of data sent over the network to the db-server during waiting.
Any ideas/hints?
Regards,
Dirk