Oracle Visual Builder: Applications That Outlive Their First Release · Module 15 · Performance
Over-fetching: the usual cause
Lesson 149 of 176 · 3 min
Asking for EVERY FIELD OF EVERY ROW to display EIGHT COLUMNS OF TWENTY. Module 6 is where this is fixed. This is the single commonest cause of a slow page in this product, and it is caused by accepting a default rather than by doing anything wrong. THE ARITHMETIC IS WHAT MAKES IT WORTH A LESSON. A Fusion resource can return well over a hundred attributes per row, and your table shows eight. So a page displaying twenty rows may be receiving twenty times a hundred values to render twenty times eight — and the ratio is frequently an order of magnitude, not a margin. AND THE ROW COUNT COMPOUNDS IT. A list with no filter fetches everything the user is entitled to see and shows a page of it — Module 6 Lesson 6 — so the over-fetch is per unnecessary row as well as per unnecessary field. THE…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Visual Builder: Applications That Outlive Their First Release, with a certificate on completion and a fourteen-day refund window.