RE: Reducing idle time in Apex
Date: Tue, 15 Mar 2022 13:34:02 -0400
Message-ID: <037f01d83892$dcfa9520$96efbf60$_at_rsiz.com>
I don’t know Apex much.
The only reason I’m chiming in is that “idle” could be send more data to client with some problem getting the “ack” to send more. The tools that have a built-in gimme fifty rows and then wait for a keyboard entry to send more crank up time similarly.
IF that or something like it is the problem I bet some APEX expert could tell you how to fix it unless it is a network eccentricity or the display machine is messed up repainting graphics.
Good luck Mark. One time in Salt Lake City Jerry and I tuned the database query in question until the database non-idle time was a blink, but we couldn’t get the output to load on a PC in another building any faster than (drumroll)… 44K. Outputting the report output to a machine in the database server room made the job run in about blink plus a tiny amount proportional to the size of the output. And I only mention that in case your 3 seconds is fast enough, there is likely nothing to remove elapsed time on the database server.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark J. Bobak
Sent: Tuesday, March 15, 2022 12:55 PM
Hi guys,
I'm running an Apex app (5.0.3) on Oracle Database 12.1.0.2. (Yes, I know these are old versions.)
When running a specific report, I get a very slow response. If I do a right-click on the page, and click 'Inspect' and then click the performance tab, and reload, I see that almost all (over 30 seconds or a 33 second response time) is 'Idle' time.
What do I do with that? Can someone help me understand this? I assume this is from the client (i.e. web server) point-of-view?
I've been doing databases for many (many!) years, but I'm not an Apex or web developer type, and never have been. The last time I was a developer it was
all about C and Pro*C.
Can someone give this old dinosaur a clue here?
Thanks,
-Mark
--
To: ORACLE-L
Subject: Reducing idle time in Apex
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 15 2022 - 18:34:02 CET