Hi everybody, our 'order' and 'orderarticles' tables have grown quite big, which dramatically slows down database interactions with these tables. For example, it takes several minutes adding a new field to those tables when installing a module.
So my question is: Is it best practise to delete old orders from oxid db? As far as I can see, the only reason to keep them is because we want to show the order history to the customer on his "account" page -- but we could instead pull them directly from the ERP (Pixi) when a customer tries to access them. So does anybody of you delete old orders in oxid? Are there any pitfalls when doing so? Reagards Dirk design3000 Vertriebsgesellschaft mbH Robert-Bosch-Str. 14 64711 Erbach Tel: +49 (0) 60 62 - 809 80 80 Fax: +49 (0) 60 62 - 918 72 18 Geschäftsführer: Frank Levita, Felix Vay Amtsgericht Darmstadt // HRB: 71307 // Ust-IdNr.: DE201696664 http://www.design3000.de/ (www.design3000.de) // http://www.koziol-shop.de/ (www.koziol-shop.de) // http://www.reisenthel.design-3000.de/ (www.reisenthel.design-3000.de) http://www.adhoc-designshop.de/ (www.adhoc-designshop.de) // http://www.sittingbull-shop.de/ (www.sittingbull-shop.de) // http://www.menushop.de/ (www.menushop.de) http://www.scheurich-shop.de/ (www.scheurich-shop.de) // http://www.fissler-shop.de/ (www.fissler-shop.de) // http://www.d3-designblog.de/ (www.d3-designblog.de) -----Ursprüngliche Daten----- Datum: 28.07.2015 18:10:12 Von: Marco Steinhaeuser < marco.steinhaeu...@oxid-esales.com > An: dev-general@lists.oxidforge.org < dev-general@lists.oxidforge.org > Betreff: [oxid-dev-general] OXID eShop versions 4.9.5 and 5.9.5 released Vorgang: T-7VCHMPB2L9-57 > Hi everybody, > > OXID eShop versions 4.9.5 and 5.9.5 have been published today. Just bug > fixes, no tpl nor lang changes. If you run an EE, please also note the > updated Varnish version: > http://wiki.oxidforge.org/Downloads/4.9.5_5.2.5 > > Regards > Marco > _______________________________________________ > dev-general mailing list > dev-general@lists.oxidforge.org > http://dir.gmane.org/gmane.comp.php.oxid.general
_______________________________________________ dev-general mailing list dev-general@lists.oxidforge.org http://dir.gmane.org/gmane.comp.php.oxid.general