幫助

0

Really slow or stuck pos loading with large number of product

I have installed odoo on 'Bitnami Launchpad for AWS Cloud'. In my database there are more then 830000 product. when I start POS it loads very slowly during product load, after some time it crash and give error : 'XmlHttpRequestError Proxy Error' (<function search_read at 0x7fb05d6f8c08>, /web/dataset/search_read: Function declared as capable of handling request of type 'json' but called with a request of type 'http')


What is the solution to optimize it to load faster.

頭像
取消
2 答案
2

Hi Vijaykumar,

There are a few options to speed up the loading and/or the cache.
You could either use the pos_cache module from Odoo (see https://www.odoo.com/apps/modules/10.0/pos_cache/ ) which will cache all products. It will be slow the first time but faster every next time.
If this is not good enough for you you could look at a PR that is currently closed. One of my colleagues has made a concept PR but it still lacked some things. You could have a look at this PR and the notes and then make your own module to improve this behaviour. You can find the PR at https://github.com/odoo/odoo/pull/17765
The speed improvements where 500%+ after testing this for us.

Regards,
Yenthe

頭像
取消
0
Avatar
Jose
最佳答案

Hi, I was reading your issues and tried to installing pos_cache but I have the same XmlHttpRequestError Proxy Error, when reading 12750 customers in POS, I am using Odoo 11. There is a rare thing, when I start a session with the Administrator user, POS start normally, but when I start a session with any other user even giving all the permissions, the error appear.

Also I archive 2000 contacts, I can start POS without problems.

Odoo is running in 2vcore machine with 2GB of RAM and 80gb SSD

Please give an idea of how to solve it.


1 評論
頭像
取消
Avatar
Kyaw Zin Oo
-

hi Jose,

Are you found the solution for your pos issue?