Vues :

Question:

The DWUserTokenIdentity table contains a large amount of entries. Are all of these entries needed?


Answer:

In the DWUserTokenIdentity table we save e.g. login tokens for the webclient and tokens for the desktop connection.
In many cases, new tokens keep getting generated and the old tokens stay in this table.
This can then lead to an incredibly high number of rows.
Those rows can be deleted periodically. In an average system, once every 1-2 months will suffice to prevent an excessive amount of entries in the table.
This kills all active user sessions however, so it should not be done during working hours.

Furthermore, this will also kill all active desktop connections so those will have to be recreated manually ( Web client -> connect desktop apps). If windows authentication is enabled, this will be done automatically after 2-5 minutes.