Enhanced Workbench Best Practices

• Maintain performance by minimizing data content by periodically evaluating components, screensets, and columns on the layouts.
• Only keep the required content on the layouts. If particular content is unused by most users, it should be added as a hidden tab. Hidden tabs only load only when they're exposed.
• Derived fields add to processing time when layout is loaded. Oracle recommends a maximum of 5-6 derived fields per screenset.
• The actions on the screenset are a part of the data content, so creating custom screen sets for tables with the minimum number of required actions can help reduce the data content and improve the performance of the workbench.
• A custom screenset with only required columns of interest to the user in the Table regions will improve performance of the layout. It's recommended to keep the number of columns to less than 20-25.
• Keep the page size smaller using these settings:
  • Go to Configuration and Administration > Preferences > User Preferences. Add the Finder Page Size preference to your user preference. This controls both Finder Results and Workbench tables. Although the default is 25, set the value to 10-12.
  • Go to Configuration and Administration > User Configuration > Screen Set Manager. On the Results tab, set the Records Per Page size. This controls the workbench table attached to this screenset.
• Tables perform best with less than 500 records.
• Gantt charts perform best when adding less than 100 objects and there's a smaller time range (around 5-7 days).