Community mailing list archives
Re: Odoo Connector VS Celery (Rabbit MQ or Redis)by
Ecosoft Co. LTD, Kitti Upariphutthiphong
Thank you for your answer. From your comment, I am not sure I understand correctly.
One of the most important difference between the 2 approaches is that the OCA connector jobs are created in the current Postgres transaction, so if your transaction fails and is rollbacked, the new jobs will never be executed because they are rollbacked too
You means, if a job (i.e., create a new record for a model) failed and roll back, that job will never be executed again? Is it possible that we program it so that it keep trying for N attempt?
And as you used to try Celery before, but then, why you come to create your own MQ system? Celery is not suitable for the work?
And lastly, can you shed some light how to start coding with Connector. I read the code in Magento-Connect, and frankly quite confused.
Appreciate your advice,
On Fri, Feb 5, 2016 at 7:11 PM, Guewen Baconnier <email@example.com> wrote:
One of the most important difference between the 2 approaches is that the OCA connector jobs are created in the current Postgres transaction, so if your transaction fails and is rollbacked, the new jobs will never be executed because they are rollbacked too. Then, as jobs are usual Odoo models, their integration and the views/wizards that can be build upon them is easier. Lastly, using Postgres as backend for the jobs means that you don't need an additional tool to maintain.I experienced a bit using Celery  before to start the connector addon.Hello,Disclaimer: I am the one of the author of the OCA's Odoo Connector.We use the OCA Connector for syncing data between systems and the synchronizations are almost real time  thanks to postgres NOTIFY .I don't have any metrics regarding the number of jobs you can execute during a day (which would largely depends of what you do in a job). If you plan to have hundreds of thousands of messages per day, you would maybe be more safe with a true message queue like RabbitMQ/Redis using Celery which are designed for that. as far as you run enough channels to execute jobs, otherwise jobs will be waiting on the others http://www.postgresql.org/docs/9.0/static/sql-notify.htmlOn Fri, Feb 5, 2016 at 11:21 AM, Kitti U. <firstname.lastname@example.org> wrote:Hello,We are choosing between OCA's Odoo Connector and Celery. Both are Message Queue system.> The main application is to sync master data between different systems and Odoo in almost real time.> The second application is to improve user experiences on performance, on where problem is, i..e, import bit data files, etc.Anyone has experience using Celery with Odoo?In your opinion, which one is better. What about Performance and Maintainability?Thanks,--