CAD Performance & Optimization Flashcards

Which SAPUI5 feature allows lazy loading of application modules to reduce initial page load time?

Answer: Component-preload.js bundling with async require

Bundling code into Component-preload.js and using asynchronous module loading minimizes initial payload and defers non-critical code.

In SAP HANA, what is the effect of creating a Calculation View instead of a Scripted Calculation View for performance-sensitive queries?

Answer: Graphical Calculation Views allow the HANA optimizer to push down operations more efficiently

Graphical Calculation Views expose the execution plan to the HANA optimizer, enabling better push-down and pruning compared to opaque scripted SQL.

What is the recommended strategy to reduce unnecessary OData backend calls in a SAPUI5 application?

Answer: Use batch requests ($batch) to group multiple OData operations into a single HTTP call

$batch combines multiple OData read/write operations into one HTTP request, reducing network round trips and improving perceived performance.

Which SAP BTP feature helps a CAD developer cache frequently read configuration data and reduce database hits?

Answer: SAP BTP Redis Cache or Application-level caching via CAP

Redis Cache or CAP's built-in caching layer stores frequently accessed data in memory, avoiding repeated database reads for the same data.

In ABAP, which optimization technique avoids loading entire database table contents into internal tables unnecessarily?

Answer: Using SELECT with a targeted WHERE clause and UP TO n ROWS

A targeted WHERE clause with UP TO n ROWS limits data transfer between the database and application server, improving runtime and memory use.

What does 'index server CPU saturation' indicate in an SAP HANA performance alert?

Answer: The in-memory column store processing cores are overloaded, causing query queuing

HANA's index server handles all column-store operations; CPU saturation means query parallelism is exhausted and queries begin queuing.