The Links table

Sitecore maintains a database table called Links.The Links table stores all links between individual items across databases (Core, Master, Web) and language versions.

Sitecore updates this table based on events that are triggered when actions on items (item:copied, item:deleted, item:saved, item:versionRemoved) are triggered.

There are two implementations of the database provider for this table:

  • SqlServerLinkDatabase (the default)

    The default provider is configured in the Sitecore.config file. You can specify which database the links are saved in. The default is Core.

  • SqlServerBatchLinkDatabase

    The main advantage of the SqlServerBatchLinkDatabase provider is storing new item links in Links table with help of batching. This improves performance considerably.

To use the SqlServerBatchLinkDatabase provider:

  • Enable the App_Config/Include/Examples/SqlServerBatchLinkDatabase.config.example file by removing the .example part of the file name.

    Note

    When you enable the new provider, Sitecore removes all data from the Links table and the provider repopulates the table.