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.
1 Response
[…] Table Type = Temporary […]