-
@dylanops95 This is basically what you'll do for the replicas: have a pool of them and spread the load using some kind of proxy/connection pool. But unlike applications where each query can be routed to different database replicas in the same request, in odoo we use transactions isolation
-
@dylanops95 This means that all queries from the same request *must* go to the same db connection from start to finish to ensure read consistency. This is why we must declare routes as readonly or not: even if a query is itself readonly, it may belong to a request that writes later on