Query caching

Question

Odoo ORM framework having own caching mechanism, but there is no support for query caching.
To
understand what is query caching please refer link below. There are two
links one of them is query caching in MySQL and another is PostgreSQL.
1. http://www.taos.com/2013/04/10/understanding-mysql-query-cache/
2. http://stackoverflow.com/questions/7142335/how-does-postgresql-cache-statements-and-data
3. https://www.percona.com/blog/2015/01/02/the-mysql-query-cache-how-it-works-and-workload-impacts-bot

Roland Lee · Accepted Answer

Try the Heimdall Proxy. It has shown to improve Odoo scale up to 20x without code changes.
It is the only solution for Odoo that can 1) Query cache and 2) Split read/writes transactions. https:/www.heimdalldata.com/odoo.
Yes, it is possible to implement query caching on the Odoo framework. But it is very complicated without a solution like Heimdall Data.

Powiązane posty	Odpowiedzi	Widoki
How solve Odoo ORM cache issue than call tools.trans_export() in a for loop? export orm cache po odoo	0 sty 16	5943
caching method orm cache memory sap caching	0 sty 16	6919
Caching System In odoo cache caching	1 paź 23	6001
Different between create/new, write/update Rozwiązane orm odoo	3 wrz 22	17704
ORM Query Search Rozwiązane orm query	7 kwi 22	14920

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!