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 -

CPU SecondsDisk ReadsBuffer GetsExecutionsBuffer Gets/Rows ProcessedElapsed Seconds
Before32.57022714177014177032.570227
After0.09859311818118180.108206

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).

Comments 6

  1. Patrick Wolf wrote:

    Hi John,

    sounds great! Are you going to share your presentation?

    Regards
    Patrick

    Posted 06 Nov 2009 at 10:58 am
  2. John Scott wrote:

    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.

    John.

    Posted 06 Nov 2009 at 11:23 am
  3. Paulo Vale wrote:

    Is this just a teaser ? :D

    Posted 06 Nov 2009 at 11:45 am
  4. StewS wrote:

    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.

    Posted 12 Nov 2009 at 10:50 pm
  5. Joel R. Kallman wrote:

    Looks like you talked them out of the Cartesian product with ALL_OBJECTS in their query.

    Posted 26 Nov 2009 at 3:49 am
  6. StewS wrote:

    I just happened to find this teaser again. Is there another post that includes the presentation file? Please??? :-)

    Thanks,

    Stew

    Posted 16 Feb 2010 at 9:55 pm

Post a Comment

Your email is never published nor shared. Required fields are marked *