Database Performance Standards · PERF-01

Where possible, regular database reindexing should be automated, e.g. a script running on a schedule.

This may not always be possible, but must always be considered.

Basic optimizations must be performed, for example:

• Projecting entities to a DTO if an untracked subset of data is needed
• Applying in-database filtering to restrict data returned to what is required
• Using the most efficient aggregation technique, e.g. if using Entity Framework, prefer Any() over Count() > 0
• If using Entity Framework, eliminate unnecessary Include() statements and don’t track entities that will not be updated