We have a client who has 12 million records in SLXRECCHANGE. Is there a safe way to delete rows from this table without harming the functionality of Exchange Link?

Kevin:

  I have ran into this in the past, and I do consider it an issue.

  Exchange Link does no maintenance on this table.

  The way that I have handled it in the past is to delete data that is older than X number of days (typically 30 just to be more than safe).

  When I did this, we did not notice any negative impact on Exchange Link.

  To understand a bit more, the way that it works, it typically creates a single entry for a given record, so for instance, if your Contact is modified 10 times, there will be only one entry for it on the table, with a timestamp of the last change. This way, when Exchange Link runs, it queries the table based on the Last Sync date, and it retreives all records that need to be updated.

  For a smaller database, this is a non-issue, but for larger databases you may feel some performance degradation (make sure your Indexes are up to date). Deleting any records that have already been processed should make no difference to Exchange Link processing, other than the fact that the Triggers will have to do a new Insert when a given record is Modified.