![]() ![]() Front end: order of files mattersįirst of all, if you are including custom CSS and JS components, make sure you put your CSS at the top of the page, and the JavaScript at the bottom. Once you feel sure your basic infrastructure is in good shape and not the culprit, it might be time to turn your attention to the application itself, meaning your front end (Javascript and CSS) and back end (SQL and PL/SQL). Are there any database locks at play? Waits? Database configuration, including possible missing indexes. You’ll want to consider problems in the browser. There are many things you’ll want to look at when assessing your application’s performance. Let’s just say that I became am avid student of Oracle APEX performance tuning, and thought I’d share some of things I have learned over the years. I was getting slammed with performance issues. While I was very excited about all the interest, I was ill-prepared for the traffic. Let’s just say I was pretty naive when I released it to the public, and never expected to be hit with thousands of users daily, generating 150,000 pageviews a day. Hey, my boys weren’t actually reading that much, so those tables were pretty small at the time… I admit at the time I was not concerned with performance, and it had a few juicy ‘select count(*) from huge table’ strategically (ahem!) sprinkled throughout. In 2010, I built an application to try to get my 2 young boys reading. And as the old saying goes, if you build it, they will come. So you’ve knocked out an awesome Oracle APEX app in a record amount of time, because, you know: #lowcode. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |