D365 Business Central : Table Type = Temporary

BC17 introduces great new features to increase your BC performance, such as partial record and temporary table type.

Creating a temporary table is the concept of holding the data temporarily in the memory which will reduce the load on the network and server. Previously, you can only do this in variable or page. Starting from BC17, you can create a table with Table Type = Temporary.

table 50000 NewTable
{
  DataClassification = CustomerContent;
  TableType = Temporary;
  fields 
   {
   }
}

This will specifies the table as an in-memory only table in the BC server. This table type is not synchronized to the database. Because of that, the table does not have restrictions on breaking schema changes.

You can start using this from BC17.

thatnavguy

Experienced NZ-based NAV Developer and Consultant with 15+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central. Passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs.

You may also like...

1 Response

  1. 31 October 2020

    […] Table Type = Temporary […]

Leave a Reply

Your email address will not be published. Required fields are marked *