8 Performance Best Practices

This topic provides tips for creating efficient data models for better performance.

Topics:

• Know Oracle WebLogic Server Default Time Out Setting

• Best Practices for SQL Datasets

• Limit Lists of Values

• Work with Lexicals/Flexfields

• Work with Date Parameters

• Run Report Online/Offline (Schedule)

• Set Data Model Properties to Prevent Memory Errors

• Tune SQL Query

• Validate Data Models