Really slow or stuck pos loading with large number of product

Question

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.

Yenthe Van Ginneken (Mainframe Monkey) · Accepted Answer

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/ [1] ) 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

Jose · Answer

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

Related Posts	Відповіді	Переглядів
Different opening when i have two or more POS pos Point Of Sale	1 бер. 24	3349
Odoo 10 POS not working after DB restore pos odoov10	1 лют. 22	2756
How to open POS from another module? Вирішено pos Point Of Sale	1 лист. 18	5606
Point of Sale, block waiters from printng the ticket and opening the cashdrawer pos Point Of Sale	2 бер. 15	5214
Kitchen and Bar printer in POS in ODOO 10 Вирішено pos restaurant Point Of Sale Posbox odoov10	2 серп. 24	9660

Це запитання позначене

Enjoying the discussion? Don't just read, join in!