Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Understand database access intent
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 Utilizing Read Scale-Out for Better Performance in the Business Central Developer and Administration help.
Change the database access intent
Select Search (Alt+Q)
in the upper-right corner, 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, where it can read or write data according to its implementation and the user's permissions. Read Only Allows the object to use a read-only database replica, if one is available. Use this setting for objects that only read data. If read scale-out isn't supported, the primary database is used instead. Choose the Edit List action.
On the Edit - Database Access Intent List page, change the Access Intent field for the objects.
Note
The list also includes ordinary pages, such as Customer Card. Changing the access intent isn't a way to make pages read-only or change users' permissions.
Related information
Business Functionality
General Business Functionality
Work with Business Central
Getting Ready for Doing Business
Start a free trial
Start a free trial!