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