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.

相关帖文	回复	查看
How solve Odoo ORM cache issue than call tools.trans_export() in a for loop? export orm cache po odoo	0 1月 16	5972
caching method orm cache memory sap caching	0 1月 16	6932
Caching System In odoo cache caching	1 10月 23	6015
Different between create/new, write/update 已解决 orm odoo	3 9月 22	17722
ORM Query Search 已解决 orm query	7 4月 22	14924

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！