Managing Database Access Intent
As a super user or administrator, you can change the database access intent on reports, pages of the type API, and queries to improve performance of the service.
Business Central can be set up to use read-only replicas of the primary (read-write) database. Using the database replica reduces the load on the primary database. In some cases, it will also improve the performance when viewing data in the client. Replicas are beneficial for objects, like reports, queries, and API pages, that are used for viewing data only, not modifying data.
When objects run, the database access intent determines whether to use a read-only replica, if one is available, or the primary database. Reports, API pages, and queries are developed with a predefined database access intent (see DatabaseAccessIntent property).
The Database Access Intent List page lets you override the predefined database access intent for objects when they're run.
In database terms, this feature is commonly known as read scale-out. For more information about read-scale out and data access intent in Business Central, see Utilising Read Scale-Out for Better Performance in the Business Central Developer and Administration help.
To change the database access intent
Choose the icon, enter Database Access Intent List, and then choose the related link.
The page lists all reports, pages, and queries. The Access Intent column includes one of the following values:
Setting Description Default Indicates that the object uses the predefined database access intent. Allow Write Sets the object to use the primary database, allowing the user to modify data. Read Only Sets the object to use the database replica, which means that the user can only view data, not change data.
Choose the Edit List action.
On the Edit - Database Access Intent List page, change the Access Intent field for the objects.
If an object that is editable, like the Customer Card, is set to Read Only, the primary database will still be used, regardless of the access intent, allowing users to make changes as normal.