Print Thread
dbms output very slow with large output
#58075 06/22/18 07:40 AM
Joined: Jun 2013
Posts: 28
D
Member
OP Offline
Member
D
Joined: Jun 2013
Posts: 28
I'm using developer version 12.
If I run this in test window, it takes ages to display the output in dbms output

BEGIN
FOR nn IN 1 .. 10000 LOOP
dbms_output.put_line(lpad('X', 80, 'X'));
END LOOP;
END;


I checked what's going on and saw this shocked No wonder it's so slow.

DECLARE
Lines SYS.DBMS_OUTPUT.chararr;
BEGIN
:NumLines := 10;
sys.DBMS_OUTPUT.get_lines (lines => Lines, numlines => :NumLines);

IF :NumLines > 0
THEN
:Line0 := Lines (1);
END IF;

IF :NumLines > 1
THEN
:Line1 := Lines (2);
END IF;

IF :NumLines > 2
THEN
:Line2 := Lines (3);
END IF;

IF :NumLines > 3
THEN
:Line3 := Lines (4);
END IF;

IF :NumLines > 4
THEN
:Line4 := Lines (5);
END IF;

IF :NumLines > 5
THEN
:Line5 := Lines (6);
END IF;

IF :NumLines > 6
THEN
:Line6 := Lines (7);
END IF;

IF :NumLines > 7
THEN
:Line7 := Lines (8);
END IF;

IF :NumLines > 8
THEN
:Line8 := Lines (9);
END IF;

IF :NumLines > 9
THEN
:Line9 := Lines (10);
END IF;
END;

Re: dbms output very slow with large output
developeris #58077 06/22/18 09:30 AM
Joined: Aug 1999
Posts: 22,249
Member
Offline
Member
Joined: Aug 1999
Posts: 22,249
We'll check it out.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.195s Queries: 14 (0.073s) Memory: 2.4988 MB (Peak: 3.0396 MB) Data Comp: Off Server Time: 2024-07-17 13:15:18 UTC
Valid HTML 5 and Valid CSS