@fishandfly You got a point, API integration is slow on Magento side (PHP + inefficient database structure).
In all case, large inventories will the lead to extra costs. On solution is to override the Magento API to allow mass update like in OpenERP, ex: create products 50 by 50, not 1 by 1. this would save some PHP but still make SQL pretty slow, not sure how much we can win, may be twice as fast. Also notice that magentoerpconnect is heavily optimized to update only things that changed meanwhile, so if you have a large catalog but not a lot of sales per hour, then you are safe. Finally, SQL integration is really hard, read http://inchoo.net/ecommerce/magento/escape-from-eav-the-magento-way/ It's doable andd has even been done, but just track you SQL logs when dealing with your Magento backoffice and you will understand that this is a crazy option (EAV + all caches to manage manually) and very brittle toward future Magento API changes. If what you want is scalability is would even be easier to code what might be missing in Spree commerce instead. Regards. ------------------------ Raphaël Valyi CEO and OpenERP consultant at http://www.akretion.com -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=60250#60250 -------------------- m2f --------------------
_______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
