Hi Dirk, in a project i am working on we do not store the orders in the database. Instead we have a custom myaccount page that fetches the orderlist from the erp (ajax). We do not have had any problems with that solution yet.
Best regards keywan Keywan Ghadami Software-Entwickler Professional Services keywan.ghad...@oxid-esales.com<mailto:keywan.ghad...@oxid-esales.com> Fon +49 761 36889-235 Fax +49 761 36889-29 www.oxid-esales.com<http://www.oxid-esales.com?campaign=emailsignatur/oxid-esales-com&adword=OXSIG_Startseite> [dmexco]<https://www.oxid-esales.com/dmexco2015/> Koelnmesse, 16.-17.09.2015, Halle 8 / Stand A-060 Jetzt Termin vereinbaren<https://www.oxid-esales.com/dmexco2015/> OXID eSales AG Bertoldstraße 48 79098 Freiburg Deutschland Vorstand: Roland Fesenmayr (Vorsitzender), Dr. Marcus Klosterberg Vorsitzender des Aufsichtsrats: Michael Schlenk, Sitz: Büdingen Amtsgericht Freiburg i. Br., HRB 701648, USt-IdNr.: DE231450866 Von: dev-general-boun...@lists.oxidforge.org [mailto:dev-general-boun...@lists.oxidforge.org] Im Auftrag von Dirk Weimar | design3000.de Gesendet: Montag, 10. August 2015 11:17 An: dev-general@lists.oxidforge.org Cc: dev-general@lists.oxidforge.org Betreff: Re: [oxid-dev-general] OXID eShop versions 4.9.5 and 5.9.5 released [T-7VCHMPB2L9-57] 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 www.design3000.de<http://www.design3000.de/> // www.koziol-shop.de<http://www.koziol-shop.de/> // www.reisenthel.design-3000.de<http://www.reisenthel.design-3000.de/> www.adhoc-designshop.de<http://www.adhoc-designshop.de/> // www.sittingbull-shop.de<http://www.sittingbull-shop.de/> // www.menushop.de<http://www.menushop.de/> www.scheurich-shop.de<http://www.scheurich-shop.de/> // www.fissler-shop.de<http://www.fissler-shop.de/> // www.d3-designblog.de<http://www.d3-designblog.de/> -----Ursprüngliche Daten----- Datum: 28.07.2015 18:10:12 Von: Marco Steinhaeuser <marco.steinhaeu...@oxid-esales.com<mailto:marco.steinhaeu...@oxid-esales.com>> An: dev-general@lists.oxidforge.org<mailto:dev-general@lists.oxidforge.org> <dev-general@lists.oxidforge.org<mailto: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<mailto: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
