community postPlatform, DevOps & Performancecommunity - not Microsoftreviewed - checked by Opus

BC Friday Tips #30 DataAccessIntent

The DataAccessIntent property can be set to ReadOnly on API pages and reports to direct the server to use a replica database, reducing load on the primary database and improving overall performance.

post That NAV Guy

Teddy Herryanto · 2025-05-02 · 77 words · about 1 min

"Set DataAccessIntent to ReadOnly when you only perform read-only data for API pages or reports."

Key points

  • DataAccessIntent property signals the server to use a replica database when available
  • Set to ReadOnly for pages and reports that only perform read-only operations
  • Reduces load on the primary database for better performance
  • A single property setting can improve system efficiency

Quotes

  • “Set DataAccessIntent to ReadOnly when you only perform read-only data for API pages or reports.” (This is the core usage guidance for when to apply the property.)
  • “It signals the server to use a replica database when available.” (Explains the mechanism of how the property improves performance.)
  • “Using the replica lessens the load on the primary database, ensuring smoother operation for others.” (Clarifies the benefit of using replica databases for read-only operations.)

Context

  • Features: DataAccessIntent property, replica database routing

Source: That NAV Guy, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.