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 Seconds | Disk Reads | Buffer Gets | Executions | Buffer Gets/Rows Processed | Elapsed Seconds | |
|---|---|---|---|---|---|---|
| Before | 32.570227 | 1 | 41770 | 1 | 41770 | 32.570227 |
| After | 0.098593 | 1 | 1818 | 1 | 1818 | 0.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
Hi John,
sounds great! Are you going to share your presentation?
Regards
Posted 06 Nov 2009 at 10:58 am ¶Patrick
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 ¶Is this just a teaser ? :D
Posted 06 Nov 2009 at 11:45 am ¶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 ¶Looks like you talked them out of the Cartesian product with ALL_OBJECTS in their query.
Posted 26 Nov 2009 at 3:49 am ¶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