Skip to Content
Menu
This question has been flagged
1 Reply
11082 Views

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-both-good-and-bad/

So my question is "It is possible to implement query caching in odoo ORM framework?"

Avatar
Discard
Best 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.

Avatar
Discard
Related Posts Replies Views Activity
0
Jan 16
5924
0
Jan 16
6895
1
Oct 23
5973
3
Sep 22
17669
7
Apr 22
14912