Increasing Scalability with Oracle Application Express

Yesterday, at the UKOUG APEX SIG (which I’ll post a follow-up about shortly), I did a quick 1 hour presentation on Increasing Scalability with Oracle Application Express, I touched on (and demonstrated) quite a few different techniques in which you can make you APEX applications more scalable (and/or just as importantly, reducing the overhead of your APEX applications).

Today, I received an email from someone who attended that presentation. I have asked their permission to post their message –

“I just thought I would let you know of the performance improvements I have got since your presentation yesterday”

and what were those improvements?

“The updateable grid has always been slow to run and was taking 1min 2seconds ( I couldn’t think how to improve it without completely redesigning it), with the changes this has been reduced to 6 seconds.”

and the difference in the production system –

[table id=2 /]

That’s quite an improvement from the users perspective, something which used to take over 30 seconds is now well under a second.

From my perspective, it’s great to know that some people were inspired to use what they learned to make some significant changes which will ultimately make their end users happier (and we’re all end users of one system or another right?).

At the UKOUG conference in a few weeks time, I’m actually going to be presenting a 2 hour Masterclass on the same topic (which allows me to go into more depth, more demos and more aspects than an hour allows).

6 thoughts on “Increasing Scalability with Oracle Application Express

  1. John Scott

    Hi Patrick,

    Yes I am, after the main UKOUG session I’m planning to release a whitepaper which goes into a bit more detail than the presentation overview would give.



  2. StewS

    Consider me teased! If I weren’t on the wrong side of the pond, I’d be dreaming of attending your talk! I guess I’ll have to wait for the whitepaper.


  3. StewS

    I just happened to find this teaser again. Is there another post that includes the presentation file? Please??? πŸ™‚





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s