Re: Reducing idle time in Apex

Thanks Mark

Rich,

We are using ORDS/Tomcat/Apache, with AJP connection for Apache<-->Tomcat.

-Mark

On Tue, Mar 15, 2022 at 2:47 PM Rich J <rich242j_at_gmail.com> wrote:

> 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