archive data

Author	« Topic »
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 06/13/2019 : 03:08:44 Hi I'm about to update a clients cart (from v6.7) and was wondering if there is any recommended way of archiving some of the historical data in the database. For example the cart table has over 20K rows, and orders over 10K with data going back 9 years. I could of course just delete a load of rows in the bigger tables but I imagine I would then end up with orphaned data in other tables and a potentially corrupt database. Any suggestions? Thanks Eric Lewis
Andy ECT Moderator 95440 Posts	Posted - 06/13/2019 : 03:41:24 Hi Eric I would be very cautious about deleting rows in the database, it's not causing any problems is it? Andy Please feel free to review / rate our software
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 06/13/2019 : 04:19:40 Hi Andy No, it's not causing any problems but I would like to make the database more manageable for backup/re-install purposes. Eric
Phil ECT Moderator United Kingdom 7622 Posts	Posted - 06/13/2019 : 04:29:30 Hi Eric, Send me an email and I'll sort something out for you. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
	« Topic »