Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rachel 5 posts 75 karma points
    Dec 01, 2016 @ 18:18
    Rachel
    0

    Delete entries from icUrlTracker table?

    Hi All, Is there a way to safely delete entries from the icUrlTracker table. We have 25 million records in this table and I'm not sure how to distinguish records that have just been logged versus redirects that have been set up by the marketing team.

    Thanks! Rachel

    Copy Link
  • Nicholas Westby 2054 posts 7103 karma points c-trib
    Dec 01, 2016 @ 18:50
    Nicholas Westby
    1

    Many of those may be 404 entries (I believe they are stored in the same table). Pretty sure there's a column named something like "Is404". Do a query for anything with that column set to true (or 1, which I believe is how SQL represents true). If those 404 entries are the majority of the records, deleting them may help.

    Copy Link
  • Nicholas Westby 2054 posts 7103 karma points c-trib
    Dec 01, 2016 @ 18:51
    Nicholas Westby
    1

    By the way, you can add these to your web.config under appSettings to ensure new entries are not automatically added going forward:

    <add key="urlTracker:trackingDisabled" value="true" />
<add key="urlTracker:notFoundTrackingDisabled" value="true" />
    Copy Link
  • Rachel 5 posts 75 karma points
    Dec 01, 2016 @ 19:15
    Rachel
    0

    Thanks, Nicholas!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft