Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Using Odoo 14 hosted by odoo.sh.
I would like to know if there are any methods or strategies to speed up search when queried by the XML-RPC API. For instance, if I want use and order of 'write_date ASC' or 'id ASC', this will cause several models to timeout when attempting to return even a single record. Do I need to set indexes on all models that I want to set an order for to make the queries more efficient? Any help is appreciated. Thanks.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Jan 24
|
5169 | ||
|
1
Jul 23
|
4581 | ||
|
0
Apr 22
|
3843 | ||
|
0
Mar 22
|
3127 | ||
|
2
May 21
|
10537 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
I don't have the karma to reply to the answer (weird system, but ok), so I'll just reply here. Is there anything that can be done in addition to just allocating more resources? If I was making SQL queries right to the DB, I'd ensure I had proper indexes. What if anything can be done with only access to the XML-RPC API? Thanks for your help.
Odoo.sh is a SharedHosting for Odoo it has it's own configuration that is limited to the resources you have so if you want your quries to be faster you have to increase your resources and increase the timeout limit.
If you have worked with a VPS server before all the configuration will be in odoo.config file and you can specify the time out and the db connections limit and you can customize what you want.
But in Odoo.sh that is all taken care of for you so just increase the resources and workers and the timeout limit if you have access rights to do so. if you don't Odoo.sh has a dedicated server plan and if you don't you can work with a VPS but it will take you more time to do it and monitor your server's security, Memory etc.
Happy to help :) an upvote will be awesome