Using Better Coding Techniques for Improved Performance

This section discusses how to:

  • Run a SQL trace.

  • Optimize SQL.

  • Use the GetNextNumberWithGaps function.

  • Consolidate PeopleCode programs.

  • Move PeopleCode to a component or page definition.

  • Send messages in the SavePostChange event.

  • Use metadata and the RowsetCache class.

  • Setting MaxCacheMemory