What is Parallel Processing and how does it works in Navision 2018?

(1) Share

Report

Posted on by joshtechsolutions

4,979

Hi Community,

May I ask explain what is Parallel Processing?

Can anyone gives me an example of how Parallel Processing this scenario works ?

Thank you!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

YUN ZHU

95,595 Super User 2025 Season 2 on at

Like (1)

Report

Hi, hope the following helps.

https://yzhums.com/5983/#toc2

Option	Description
Sequential	(Default) The whole dimension change is done in one transaction taking all entries back to the dimensions they had before the change. This option is recommended if the company contains relatively few posted entries where it will take the shortest time to complete. The process locks multiple tables and blocks other users until it is done. Note that on large databases, the process may not be able to complete at all in this mode. In that case, use the Parallel option.
Parallel	(Select the Parallel Processing checkbox.) The dimension change is done as multiple background sessions and the operation is split into multiple transactions. This option is recommended for large databases or companies with many posted entries where it will take the shortest time to complete. Note that with this mode, the update process will not start if there are more than one active database session.

Option

Description

Sequential

(Default) The whole dimension change is done in one transaction taking all entries back to the dimensions they had before the change.
This option is recommended if the company contains relatively few posted entries where it will take the shortest time to complete. The process locks multiple tables and blocks other users until it is done. Note that on large databases, the process may not be able to complete at all in this mode. In that case, use the Parallel option.

Parallel

(Select the Parallel Processing checkbox.) The dimension change is done as multiple background sessions and the operation is split into multiple transactions.
This option is recommended for large databases or companies with many posted entries where it will take the shortest time to complete. Note that with this mode, the update process will not start if there are more than one active database session.

Thanks.

ZHU