Re: Reducing idle time in Apex

What are you using to serve up the APEX pages? I believe APEX 5 still supported the embedded PL/SQL gateway. It's very slow for even a single user, although I don't recall where in the response time that slowness occurred. Once I converted to ORDS/Tomcat, the response was snappy...

My $.02,
Rich

On Tue, Mar 15, 2022 at 12:35 PM Mark W. Farnham <mwf_at_rsiz.com> wrote:

> 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
> *To:* ORACLE-L
> *Subject:* Reducing idle time in Apex
>
>
>
> 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
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l