Help

1

Really slow or stuck pos loading with large number of product

Avatar
Vijaykumar Baladaniya

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.

Avatar
Discard
2Answers
3
Best 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/ ) 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

Avatar
Discard
0
Avatar
Jose
Best 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 give an idea of how to solve it.


1Comment
Avatar
Discard
Avatar
Kyaw Zin Oo
-

hi Jose,

Are you found the solution for your pos issue?