HI everyone
I'm doing some year-end housekeeping. In particular, I'd like to tackle the TR_WEB_SOURCE_NO table which is where you link your Source No for an offer to a user-friendly Promo code for use in TNEW. This table has never had anything deleted in over 10 years. Some entries have been inactivated, but there are many still active from previous years which are no longer in use as they relate to past seasons/events.
What's best practice for managing these? Do you delete entries or just inactivate them? I'd like to delete the really old ones and just inactivate the more recent ones. The documentation for this table does not cover inactivation or deletion. I'm assuming it does not affect reporting as this is usually by Source No/Name rather than promo code.
Any thoughts/reassurances welcome!
Many thanksBest wishes
Dawn
We keep them all, but inactivate once the promo is passed. We like to be able to look back at what promo codes and what help text was used. It is simply second nature to sort by the "inactive" column the moment that table is loaded when building new promos. We have experienced no noticeable performance issues thus far.
That said, Gawain Lavers's local table back-up idea has a lot of merit to it. I may consider.