I was wondering. I sometimes have to do some database "clean up" on some Umbraco sites by deleting old data in the umbracoLog table to save database storage space.
Can I do something similar with the nsEmailTrackingItems and nsTrackingItems tables, or do I risk breaking Newsletter Studio?
If you want to "do it right" you should remove everything from the UI.
If you want to try to do it with a sql-statement make sure to remove the actual newsletters as well (nsNewsletters) so that your users don't click on them in the UI and get errors due to the fact that the tracking items are gone.
Database "clean up"
Hi
I was wondering. I sometimes have to do some database "clean up" on some Umbraco sites by deleting old data in the umbracoLog table to save database storage space.
Can I do something similar with the nsEmailTrackingItems and nsTrackingItems tables, or do I risk breaking Newsletter Studio?
Kind regards, Bruno
Hi!
If you delete an email the needed items in these tables will be removed as well.
If you want to keep the statics for the e-mails you can't remove these items as they are the statics =D
/ m
Hi Markus
So, if I don't need the statistics for say two year old newsletters, I won't break Newsletter Studio by removing rows in those tables, correct? :)
Kind regards, Bruno
Hi!
Probably not =D
If you want to "do it right" you should remove everything from the UI.
If you want to try to do it with a sql-statement make sure to remove the actual newsletters as well (nsNewsletters) so that your users don't click on them in the UI and get errors due to the fact that the tracking items are gone.
// M
Hi Markus
Ok, thanks. I think I'd better have them delete the old newsletters they don't need anymore themselves then ;)
Kind regards, Bruno
is working on a reply...