Skip to main content

Employee Performance Characteristics

Summary​

Employee read paths use async EF Core operations, no-tracking queries, server-side filtering, bounded paging, sorting, and projection. No application cache, distributed cache, Employee background worker, benchmark, or source-defined service-level objective was found.

Audience​

  • Backend developers and QA engineers
  • DevOps engineers and solution architects

Reference Content​

Query optimization​

  • Search starts from a tenant-filtered, no-tracking query.
  • Filters are composed before count, sort, paging, and projection.
  • Search projects only the result fields needed by the search read model.
  • Paging input is normalized and page size is bounded.
  • Sort fields are restricted to a known list with a deterministic default.
  • Timeline reads are no-tracking, newest-first, and tenant feed size is bounded.
  • Department/designation list queries use no tracking and server-side ordering/projection.

Aggregate loading​

Full-profile reads explicitly load multiple employee child collections. This is appropriate for complete profile operations but may become expensive for large profiles. No split-query configuration or profile-section lazy loading was found; scale behavior Requires confirmation.

Caching​

No in-memory or distributed Employee cache is registered. Every confirmed read path uses persistence directly.

Async and background processing​

Application and persistence operations are asynchronous and accept cancellation tokens. Command requests create outbox records during commit rather than synchronously contacting downstream services. However, no hosted Employee relay processes those records in the current host.

Requires confirmation​

  • Production data volumes and latency targets.
  • Query plans and index effectiveness at scale.
  • Search-provider replacement criteria.
  • Cache policy, profile-loading strategy, rate limiting, and load-test coverage.

Source References​

  • microservices/src/employee-service/Infrastructure/PostgresEmployeeSearchProvider.cs
  • microservices/src/employee-service/Infrastructure/Persistence.cs
  • microservices/src/employee-service/Application/Search/EmployeeSearch.cs
  • microservices/src/employee-service/Application/Queries/EmployeeApplicationQueries.cs

See Also​

Keywords​

  • Server-side paging
  • No-tracking query
  • Cache status

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-15
  • Review cycle: Quarterly