Debug Output – 20.1 APEX 20.1 Performance
#PL SQL DEVELOPER PLUGIN CODE#
And by healthy, of course, I mean being able to focus on what’s important instead of parsing and compiling code over and over. The more concurrent users or page views you have the healthier your DB will be. That said, I still strongly recommend you compile your plugin code. So, even though we still need to hard parse, even if you have 50 instances of the plugin on the page, it only gets parsed once. Starting with 19.2, we are parsing plugin code only once per request, to reduce parses when a plugin is used several times on a page. Plugin code is parsed only once per page request. The Silver LiningĪPEX 19.2 brought a fantastic optimization. Imagine if you could shave 2.5s of your page rendering by doing nothing but compiling the code of your plugins. Thirty Select2 page items on a page may sound like a lot, but it’s not unreasonable in a complex page. The page took ~2.7 sec to render with inline code, but only 0.27 sec with compiled code! APEX 5.1 - 30 Select2 Items - Compiled CodeĪnd the results were surprising. APEX 5.1 - 30 Select2 Items - In-line CodeĢ. I set up a page with 30 items using the, extremely popular, Select2 plugin.ġ. How expensive is hard parsing you ask? Well, I’m glad you asked.
![pl sql developer plugin pl sql developer plugin](https://felipezorzo.com.br/static/ad2d0338f3cd4cdfa99d4d646bcaa3b1/77d28/invalid_reference_to_object_example.png)
This is expensive and it’s slowing down your applications. This means that every time a plugin with inline code is used the code needs to be parsed (hard parsed, that is) and compiled. This is relevant because many of the plugins you may use in your applications ship with “inline” code. Now, Hard Parsing, in particular, is a very expensive operation. For practical purposes, the first time the code is read and understood is called Hard Parsing, after that, it will be Soft Parsing. Let me explain.īefore the Oracle database can execute your code (either SQL or PL/SQL), it needs to understand it. This blog post is about performance Not about writing plugins.ĪPEX 20.1 is out now, but this information applies to all version of APEX, but it will be especially of interest if you’re on a version earlier to 19.2.