web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / That NAV Guy / Table Type = Temporary

Table Type = Temporary

Teddy Herryanto (That NAV Guy) Profile Picture Teddy Herryanto (Th... 14,306 Super User 2026 Season 1

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.


This was originally posted here.

Comments

*This post is locked for comments